topic Re: 100 % stacked bar chart for multiple dimensions in App Development

100 % stacked bar chart for multiple dimensions

yipchunyu — Thu, 26 Mar 2020 04:22:46 GMT

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).

Re: 100 % stacked bar chart for multiple dimensions

yipchunyu — Thu, 26 Mar 2020 06:18:34 GMT

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)

Re: 100 % stacked bar chart for multiple dimensions

Sagar082 — Thu, 25 Jun 2020 10:14:15 GMT

Hi,

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