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
