Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
yipchunyu
Creator
Creator

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
yipchunyu
Creator
Creator
Author

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

2 Replies
yipchunyu
Creator
Creator
Author

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)

Sagar082
Creator
Creator

Hi,

Greeting for the day. It throughed error, but giving desire output.