hy everybody.
Below is the excel file and I need to calculate in qlikview the column "Total Qty" and "Qty %".
Total Qty is the total sum of product grouped by Category.
Qty % is the sum of product / total sum of product grouped by Category
In qlikview I need to create a table with only dimension Product and expression "Total Qty" and "Qty %"
In attached my qvw file where I try to calculate "Total Qty" and "Qty %" but it dosnt work.
The expression that I create is:
SUM(Qty)/aggr(SUM( Qty),Category)
Can you help me?
Thanks
Category | Product | Qty | Total Qty | Qty % |
CATEGORY 1 | PRODUCT 1 | 132 | 2450 | 5.387755 |
CATEGORY 1 | PRODUCT 2 | 380 | 2450 | 15.5102 |
CATEGORY 1 | PRODUCT 3 | 1891 | 2450 | 77.18367 |
CATEGORY 1 | PRODUCT 4 | 47 | 2450 | 1.918367 |
CATEGORY2 | PRODUCT 5 | 50 | 116 | 43.10345 |
CATEGORY2 | PRODUCT 6 | 66 | 116 | 56.89655 |