Twitter/Facebook

Pinterest
Friday, October 3, 2014

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
;


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 :)

LinkWithin

Search This Blog

 
badge