Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Ronald
Contributor III
Contributor III

Value and Percent in stacked bar

Hello everyone
I would like to visualize the value and % (12.0K  - 100%)(30 - 0.25%) of the stacked bar for each of the months, as shown in the graph.

Best Regards,

stackedBar.PNG

 

Labels (1)
2 Replies
QFabian
Specialist III
Specialist III

Hi @Ronald , if you use a formula like this :

Sum(Value) / sum(total <Period> Value)

you can get something like this :

QFabian_0-1618875283505.png

This is the sample script :


Load * inline [
Period, Value, Part
1, 2, 1
1,3,2
1,4,3
1,5,4
2,3,1
2,4,2
2,5,3
2,6,4
3,4,1
3,5,2
3,6,3
3,7,4
4,5,1
4,6,2
4,7,3
4,8,4
];

QFabian
Ronald
Contributor III
Contributor III
Author

Thanks, but I need to show both values #,% on the stacked bar