topic Re: Percentages in Stacked bar Chart in QlikView

Percentages in Stacked bar Chart

Thu, 25 Jul 2013 01:57:21 GMT

i have an expression called Volume.

I wanted to show a satcked bar chart where - the total volume is 100%, and split by regions with percentages.

Thanks,

Thejo.

rwunderlich — Thu, 25 Jul 2013 02:34:01 GMT

Use Region as the second dimension. I assume you have a primary dimension like "Year".

Use sum(Volume) as the expression and check the "Relative" checkbox on the expression pane.

-Rob

Thu, 25 Jul 2013 03:09:40 GMT

Yes, Primary dimension is month.

Secondary is region.

when i used the relative check box, it is not showing 100%, it shows as below. if select one month tehn it shows 100%.

koushik_btech20 — Thu, 25 Jul 2013 05:53:26 GMT

Please see the .qvw file which is attached. I think it will help u....

Thu, 25 Jul 2013 06:29:39 GMT

this is not yet working for me. my numbers are different. i have changed the numbers from your sheet,

Thu, 25 Jul 2013 06:32:02 GMT

i missed the attachment in the earlier one.

Gysbert_Wassenaar — Thu, 25 Jul 2013 08:41:02 GMT

See attached example.