Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Using Set Analysis for Comparing Charts

Hello together,

i have one question:

I have two Dimensions:

Dimension 1 called Group with the fields A B C

Dimension 2 called SubGroup with the fields a b c

My Application should show 2 diagramms. The first one should contain values of A a and the second one should show values A b.

I need the two diagramms to compare the values. If i select A a the diagramm should show the values of A a and then, if i select A b the first diagramm should stay on the screen and a second one for the values A b should be shown, so that i can compare the both diagramms with different values.

I heard that i can realize this case with the Set Analysis Function but i don't know, how to do it.

Can anyone please help me?

Thanks!

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Using Set Analysis for Comparing Charts

Hi,

May be your script should be like this

QUALIFY*;

UNQUALIFY key;

Group:

LOAD * INLINE [

    key, field

   

    1, A

    2, B

    3, C

];

UNQUALIFY*;

QUALIFY *;

UNQUALIFY key;

SubGroup:

LOAD * INLINE [

  key,  field

   

   1, a

   2, b

   3, c

];

UNQUALIFY*;

QUALIFY *;

UNQUALIFY key;

Value:

LOAD * INLINE [

  key,  value

   

   1, 10

   2, 20

   3, 30

];

UNQUALIFY*;

Regards,

Jagan.

View solution in original post

15 Replies
Highlighted
Creator
Creator

Using Set Analysis for Comparing Charts

Can you attached your working file?

Highlighted
Not applicable

Using Set Analysis for Comparing Charts

I attached the working file.

if i select A a 10 the diagramm shows the correect values. but i want a a second diagramm BEHIND the first diagramm that show the value 20 if i select A b 20 without the first diagramm is moving.

Highlighted
MVP & Luminary
MVP & Luminary

Re: Using Set Analysis for Comparing Charts

Hi,

Check the attachment for solution.

Hope this helps you.

Regards,

Jagan.

Highlighted
Not applicable

Re: Using Set Analysis for Comparing Charts

Thanks Jagan, this solution will help me!

Highlighted
Not applicable

Re: Using Set Analysis for Comparing Charts

One question Jagan, your solution shows the value 20 for both diagrams but i want that the first diagramm should show 10 and the second diagramm sould 20 as values. Can you help me to change this?

Highlighted
MVP & Luminary
MVP & Luminary

Using Set Analysis for Comparing Charts

Hi,

For Group A and SubGroup a there are two values (10 and 20), I used Sum() in the expression.  That is why it is showing you as 30. 

Please check your data, whether you should have only only value for A a and A b.

If there is one to one mapping values then this would be automatically fixed.

Regards,

Jagan.

Highlighted
MVP & Luminary
MVP & Luminary

Using Set Analysis for Comparing Charts

Hi,

May be your script should be like this

QUALIFY*;

UNQUALIFY key;

Group:

LOAD * INLINE [

    key, field

   

    1, A

    2, B

    3, C

];

UNQUALIFY*;

QUALIFY *;

UNQUALIFY key;

SubGroup:

LOAD * INLINE [

  key,  field

   

   1, a

   2, b

   3, c

];

UNQUALIFY*;

QUALIFY *;

UNQUALIFY key;

Value:

LOAD * INLINE [

  key,  value

   

   1, 10

   2, 20

   3, 30

];

UNQUALIFY*;

Regards,

Jagan.

View solution in original post

Highlighted
Not applicable

Re: Using Set Analysis for Comparing Charts

You'r right. Thank you very much!

Highlighted
MVP & Luminary
MVP & Luminary

Using Set Analysis for Comparing Charts

Hi,

If there is one-to-one mapping in your data then you can use Only() instead of Sum().

Regards,

Jagan.