Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kenphamvn
Contributor III

Compare value in one table with same dimension column

Hi All

i have one table like this

5-21-2018 3-27-52 PM.png

in Qlik dashboard, i want to compare sum Amount by two Group like this

5-21-2018 3-05-14 PM.png

- 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

1 Solution

Accepted Solutions
agigliotti
Honored Contributor II

Re: Compare value in one table with same dimension column

you should use alternate states.

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

I hope it helps.

3 Replies
agigliotti
Honored Contributor II

Re: Compare value in one table with same dimension column

you should use alternate states.

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

I hope it helps.

isorinrusu
Contributor III

Re: Compare value in one table with same dimension column

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
Contributor III

Re: Compare value in one table with same dimension column

Hi Andrea

it's work for me

Thanks you very much.

Regards

An Pham

Community Browser