100 % stacked bar chart for multiple dimensions

[yipchunyu]

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

[yipchunyu · Accepted solution]

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]

Hi,

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