Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
aarav021
Contributor III
Contributor III

100% Stacked bar chart with Average

Dear all, 

I want to represent Average hit count I want to show stacked bar chart showing the average hit count. I am able to show sum of hit count, also count of hit count. But not getting 100% share if using average. 

It's urgent requirement please if anyone could help me in this 

2 Replies
HeshamKhja1
Partner - Creator II
Partner - Creator II

Hi @aarav021 ,

One day later although it is urgent to you, I didn't get what you mean by 100% Share? what are you expecting the chart to be?

I used below sample:

T1:
LOAD * Inline [
Month, Categ, Value
1, Misc, 1
1, Mailers, 1
1, Banners, 1
1, Posts, 2
1, Misc, 3
2, Misc, 3
2, Mailers, 2
2, Mailers, 3
2, Mailers, 4
];

Created two charts, 1) Using Sum. 2) Using Avg.

HeshamKhja1_0-1698824644333.png

Everything seems correct. What did you encounter?

 

aarav021
Contributor III
Contributor III
Author

By 100% what I mean is that the total share for the categories should sum to 100%