Qlik Community

Qlik Sense App Development

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

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Contributor

100 % stacked bar chart for multiple dimensions

I created a bar charts with two dimensions (with more than 2 dimensions on it) and multiple alternative measures.

I found that it can show correctly as a stacked chart.

However, I want to make it as 100% stacked chart and so easy to compare the % of different combinations e.g. Product Type, Age group against Sales amount.

I read some posts that suggest to calculate like
=Sum({<Basic_OR_Rider={'B'}>} ANP_USD) / Sum(Total {<Basic_OR_Rider={'B'}>} ANP_USD)

But it's not what I expected to look.  is it possible to do so in Qliksense?  (I also read someone suggest to use GetCurrentFIeld function but I have no idea on how to make it works).

1 Solution

Accepted Solutions
Highlighted
Contributor

Re: 100 % stacked bar chart for multiple dimensions

Found the solution which I should use GetObjectField function as below:


Sum({<Basic_OR_Rider={'B'}>} ANP_USD)/Sum(Total <$(=GetObjectField(0))> {<Basic_OR_Rider={'B'}>} ANP_USD)

View solution in original post

1 Reply
Highlighted
Contributor

Re: 100 % stacked bar chart for multiple dimensions

Found the solution which I should use GetObjectField function as below:


Sum({<Basic_OR_Rider={'B'}>} ANP_USD)/Sum(Total <$(=GetObjectField(0))> {<Basic_OR_Rider={'B'}>} ANP_USD)

View solution in original post