topic Re: Using Set Analysis for Comparing Charts in QlikView

Using Set Analysis for Comparing Charts

Mon, 13 Feb 2012 06:24:34 GMT

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!

Using Set Analysis for Comparing Charts

Qvmaster2019 — Mon, 13 Feb 2012 06:31:32 GMT

Can you attached your working file?

Using Set Analysis for Comparing Charts

Mon, 13 Feb 2012 06:49:22 GMT

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.

Re: Using Set Analysis for Comparing Charts

jagan — Mon, 13 Feb 2012 07:03:15 GMT

Hi,

Check the attachment for solution.

Hope this helps you.

Regards,

Jagan.

Re: Using Set Analysis for Comparing Charts

Mon, 13 Feb 2012 07:07:26 GMT

Thanks Jagan, this solution will help me!

Re: Using Set Analysis for Comparing Charts

Mon, 13 Feb 2012 07:15:26 GMT

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?

Using Set Analysis for Comparing Charts

jagan — Mon, 13 Feb 2012 07:20:53 GMT

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.

Using Set Analysis for Comparing Charts

jagan — Mon, 13 Feb 2012 07:22:08 GMT

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

diagramm shows 10 ? your expression =Sum(Value.value) is not ok in this context.

In my first question you can see the second file SetAnalysis2.qvw

Using Set Analysis for Comparing Charts

jagan — Mon, 13 Feb 2012 10:07:04 GMT

Hi,

If you always need to show A a 10 in the first chart then use the expression

=only({<Group.field={'A'}, SubGroup.field={'a'}>} Value.value) It always show 10. Becuase we are hard coded the values.

But in you chart you have the expression =only({$}Value.value), it always change based on the current selection.

Regards,

Jagan.