Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
Im trying to compute in qlikview the % of dimension 1 as i show in the last column below.
In my data i have lots of fields in dimension 1, in this example i only use numbers 1 and 2.
Can anyone help me finding a formula that calculates how many cases exists from dimension 2 in the total of dimension 1.
Ex: Dimension 1 = 1
Dimension 2 = A, B, C, D
I want to compute the percentage of A in the total dimension 1 =1 , the percentage of B in the total of dimension 1=1.
Dimension1 | Dimension 2 | Count values | % | % of Dimension 1 |
1 | A | 10 | 7% | 14% |
1 | B | 20 | 14% | 29% |
1 | C | 30 | 21% | 43% |
1 | D | 10 | 7% | 14% |
2 | A | 10 | 7% | 14% |
2 | B | 20 | 14% | 29% |
2 | C | 30 | 21% | 43% |
2 | D | 10 | 7% | 14% |
Best regards,
Eliano Marques
Hi, try this:
count(distinct Value)/ count(total <Dimension1> distinct Value)
Regards