topic Re: Chart % in QlikView

Chart %

Thu, 16 Aug 2012 14:21:27 GMT

Hi All,

I have data as under.

load *

inline

[exp,amt

Gros, 20

Travel,50

Ent,20

others,10

];

I want to plot a chart for total exp is 100, on each expense i want to show % of total exp by category

Gros is 20% of total expense,

Travel is 50% of total exp

Please help.

Thanks..

Re: Chart %

mphekin12 — Thu, 16 Aug 2012 14:29:00 GMT

Use 'exp' as your dimension and '=amt/sum(all amt)' as your expression. On the 'Number' tab click 'Show in Percent'. Hope that helps.

Re: Chart %

manojkvrajan — Thu, 16 Aug 2012 14:34:54 GMT

Attached is the sample to display both Amount and Amount %. I hope it helps.

Re: Chart %

Thu, 16 Aug 2012 14:35:51 GMT

Thank you, i used that. It works,

I am sorry, I was not clear. I want to show bar with different color of %. all bar has same color for total and then % of color will be different based on category.

Lets say total amt barr is blue and i eant to change 50% bar to green for travel category. so my bar will look half green and half blue. I am trting with back ground color, but some how not getting it.

Re: Chart %

Thu, 16 Aug 2012 14:39:04 GMT

Seems quite simple.

In Dimension, you select 'exp'

In expression, use this formulae: amt/sum(all amt). It would display in decimal value. If you want in %, go to Number format and select 'Fixed To' and enable the Show in Percent(%).

Please check.

Re: Chart %

Thu, 16 Aug 2012 14:43:29 GMT

Thank you, i used that. It works,

I am sorry, I was not clear. I want to show bar with different color of %. all bar has same color for total and then % of color will be different based on category.

Re: Chart %

mphekin12 — Thu, 16 Aug 2012 14:44:44 GMT

Will something like this work?

Re: Chart %

Thu, 16 Aug 2012 15:17:36 GMT

Thanks,

I think this is what i wanted but value on data point doen't show for individual. I am not sure may be it is hiddle under becuase of stacked char. Am I missing anything here.

PLease let me know.

Re: Chart %

mphekin12 — Thu, 16 Aug 2012 15:20:36 GMT

Here it is with different colors and text on axis.

Re: Chart %

Thu, 16 Aug 2012 15:41:12 GMT

thank you so much. I wanted to show it at data point but shome how it is not showing.

Re: Chart %

mphekin12 — Thu, 16 Aug 2012 15:47:17 GMT

It might be due to the fact that it is a stacked bar chart.