Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

qdatainformatic
New Contributor II

Stacked bar chart that adds 100% from multiple columns

Given the following data, how can i produce a graph that shows:

 

CATMONTHF1F2F3
111
116
114
112
213
214
215
22 2
22 3
32 5
32 6
32 7
32 8
32 9
33 1
43 2
43 3
43 4
43 5
53 6

The Column CAT as a dimension

The Column Month as a sub-dimension

The Sum of F1+F2+F3 as a stacked bar chart, that always has a total of 100%

Tags (1)
4 Replies
MVP
MVP

Re: Stacked bar chart that adds 100% from multiple columns

May be this

=Sum(RangeSum(F1, F2, F3))/Sum(TOTAL <CAT> RangeSum(F1, F2, F3))

Capture.PNG

qdatainformatic
New Contributor II

Re: Stacked bar chart that adds 100% from multiple columns

Hi,

That's almost it, there's only one point that i didn't explain in my opening post.

The Sum of F1 should only be calculated when the month=1.

The Sum of F2 should only be calculated when the month=2.

The Sum of F3 should only be calculated when the month=3.

I modified my example data, only the values in bold should be calculated:

 

CATMONTHF1F2F3
11125
11636
11457
11268
21373
21482
21533
22225
22336
32557
32668
32779
32887
32992
33371
43582
43693
43724
43835
53856
MVP
MVP

Re: Stacked bar chart that adds 100% from multiple columns

May be like this

=Sum(RangeSum(Pick(MONTH, F1, F2, F3)))/Sum(TOTAL <CAT> RangeSum(Pick(MONTH, F1, F2, F3)))

MVP
MVP

Re: Stacked bar chart that adds 100% from multiple columns

Sample attached

Capture.PNG