Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all, I have the following straight Table, with a dimension of company, and expressions are val1, val2, val3 and i want to know how to calculate the difference between companies automatically. How do i do that?
Based on the selection of company(List box) then difference will find out ,here Company values are Dynamically selected from the list box
Input :
company | a(a1) | b(b1) | c(c1) |
val1 | 12 | 10 | 15 |
val2 | 10 | 15 | 23 |
val3 | 14 | 12 | 11 |
Required Output:
company | a(a1) | b(b1) | c(c1) | a(a1) Vs b(b1) | a(a1) Vs c(c1) | b(b1) Vs c(c1) |
val1 | 12 | 10 | 15 | 2 | -3 | -5 |
val2 | 10 | 15 | 23 | -5 | 13 | -8 |
val3 | 14 | 12 | 11 | 2 | 3 | 1 |
HI,
normally it's just a simple: fields minus fields.
share your qlikview file or samplel data to see clearly
Hi ZaRRA , Thank you for You'r Response
I am selecting from the Company names list ,
Depends on the selection , the combinations of the difference will be generate , in the output.
Here i am selecting only 3 company names ,so the combinations will be 6 . if select more than that with respect combination of the differences will be generate .
I hope explained clearly.
Check out the following Help link, may work, but I am not certain:
This only works in a Straight Table chart, just FYI.
Regards,
Brett