Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
i have one table like this
in Qlik dashboard, i want to compare sum Amount by two Group like this
- KPI Amount 1 only affected by left Products Filter and Amount 2 only affected by right Products Filter
- Left and right Products filter not affected by each other
I don't know, Qlik sense can do it or not with one table?
if yes, how to do
if no, Is there a way to do it?
Regards
An Pham
you should use alternate states.
take a look at Comparative Analysis - Alternate States with Qlik Sense
I hope it helps.
you should use alternate states.
take a look at Comparative Analysis - Alternate States with Qlik Sense
I hope it helps.
There are quite a few ways to do it.
A simple one:
Duplicate the field so that you have Products_A and Products_B. Use one at the left and the other one at the right. Then, in your expressions, use Set Analysis to ignore the field you don't want (e.g. Sum({<Products_B>} Sales) when you're using it for the left KPI where only Products_A selections apply).
Hope it helps.
Regards,
Sorin.
Hi Andrea
it's work for me
Thanks you very much.
Regards
An Pham