Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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.
Can you attached your working file?
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.
Hi,
Check the attachment for solution.
Hope this helps you.
Regards,
Jagan.
Thanks Jagan, this solution will help me!
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?
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.
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.
You'r right. Thank you very much!
Hi,
If there is one-to-one mapping in your data then you can use Only() instead of Sum().
Regards,
Jagan.