Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am new user of Qlikview and am trying to calculate the % for each product based on the following data set.
Type | Account | Product | Units |
---|---|---|---|
A | XX | ABC | 10 |
A | XX | DEF | 50 |
A | XX | GHI | 72 |
A | YY | ABC | 62 |
A | YY | DEF | 17 |
A | YY | GHI | 46 |
I need the results to be as follows
Type | Account | Product | % |
---|---|---|---|
A | XX | ABC | 7.58% |
A | XX | DEF | 37.88% |
A | XX | GHI | 54.55% |
A | YY | ABC | 49.6% |
A | YY | DEF | 13.6% |
A | YY | GHI | 36.8% |
Please advise on most optimal way of doing this.
Thanks
Try something like this in a pivot-expression: sum(value) / sum(total <Type, Account> value)
- Marcus
sum(Units) / sum(TOTAL <Account> Units)