Compare value in one table with same dimension column

[kenphamvn]

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

[agigliotti · Accepted solution]

you should use alternate states.

take a look at Comparative Analysis - Alternate States with Qlik Sense

I hope it helps.

[isorinrusu]

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.

[kenphamvn]

Hi Andrea

it's work for me

Thanks you very much.

Regards

An Pham