Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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).
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)
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)
Hi,
Greeting for the day. It throughed error, but giving desire output.