Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart %

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..

1 Solution

Accepted Solutions
mphekin12
Specialist
Specialist

Here it is with different colors and text on axis.

View solution in original post

10 Replies
mphekin12
Specialist
Specialist

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

manojkvrajan
Luminary
Luminary

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

Not applicable
Author

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.

Not applicable
Author

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.

Not applicable
Author

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.

mphekin12
Specialist
Specialist

Will something like this work?

Not applicable
Author

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.

mphekin12
Specialist
Specialist

Here it is with different colors and text on axis.

Not applicable
Author

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