To get text on graph lets take an example:
States:
LOAD Rank as RankState,
'India' as Country,
[State or union territory],
[State or union territory] as State,
"Population(2011 Census)[12]" as Populationstate,
"Closest Comparable Country (population)[14]",
[%Decadal Growth (2001–2011)],
"Rural Pop.[15]",
"Urban Pop.[15]"
//"Area[16]",
//Density,
// [Sex ratio]
FROM
[D:\Ganga Bharani- Writer\hp office#\qlikview\state population.xls]
(biff, embedded labels, table is Sheet1$)
where "Population(2011 Census)[12]">0 and "Rural Pop.[15]">0 and "Urban Pop.[15]">0
;
States:
LOAD Rank as RankState,
'India' as Country,
[State or union territory],
[State or union territory] as State,
"Population(2011 Census)[12]" as Populationstate,
"Closest Comparable Country (population)[14]",
[%Decadal Growth (2001–2011)],
"Rural Pop.[15]",
"Urban Pop.[15]"
//"Area[16]",
//Density,
// [Sex ratio]
FROM
[D:\Ganga Bharani- Writer\hp office#\qlikview\state population.xls]
(biff, embedded labels, table is Sheet1$)
where "Population(2011 Census)[12]">0 and "Rural Pop.[15]">0 and "Urban Pop.[15]">0
;
Use the above script to load the population state wise for Indian states.
Create a Mekko Chart. I have used this chart to show the urban and rural population split in each state.
Dimension: State
Expressions:
dual(State,(sum("Rural Pop.[15]")/sum(Populationstate))*100)
dual(State,sum("Urban Pop.[15]")/sum(Populationstate)*100)
You can take any example, I am using this for the benefit of people learning it along with my learning diary.
step 1:
Step2:
Outcome:
0 Scribbles:
Post a Comment
Thank You for taking pains, commenting :)