Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
kenphamvn
Creator III
Creator 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
Partner - Champion
Partner - Champion

you should use alternate states.

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

I hope it helps.

View solution in original post

3 Replies
agigliotti
Partner - Champion
Partner - Champion

you should use alternate states.

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

I hope it helps.

isorinrusu
Partner - Creator III
Partner - Creator III

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
Creator III
Creator III
Author

Hi Andrea

it's work for me

Thanks you very much.

Regards

An Pham