How to show Contribution in Pie Chart in Qlik View?

[#1]

Hello all,

I am working with Qlik View 11 Personal Edition I have the data like this

Age Group	Number of Students
20-22	30
23-25	20
25 and above	50

Now I want to show a pie chart to represent contribution.

i.e., if I select "20-22" from the list box, pie chart should show two parts 20-22 (30%) and Others (70%).

I tried "Dimension Limits" by selecting "First" "1" values and "Show Others". But now luck.

Any clues?

[ecolomer]

Use alternate states

[ecolomer]

In pie chart your requeriment aren't possible, but yes in pivot table as this:

[vikasmahajan]

you can store grand total in variable vgtot  and use this variable as fourmula   no of students/ vgtot  in number format choose show in %

Hope this helps you

Vikas

[#5]

Hi,

Thank you for the solution. Is it possible to show the totals as percentage?

[#6]

Hi Vikas,

Thank you for the solution. I tried it but no luck.

[rwunderlich · Accepted solution]

You should be able to do this with a Calculated Dim of:

  =aggr(if(only({1}[Age Group])=[Age Group],[Age Group],'Others'),[Age Group])

and an Expression of

  sum({1}[Number of Students])

with Relative checked.

See attached example.

-Rob

http://masterssummit.com

http://robwunderlich.com

[ecolomer]

Yes ..

[Agis-Kalogiannis]

Hi Ravindra

I think the following is exactly what you are looking for.

Please let me know if you need anything else.

Thanks

Agis

[#10]

Thank you so much.