Discussion board where members can get started with QlikView.
I have the following table:
What I need is to do this:
I need to add 2 expressions:
- Total: Sum of Qty for each Area. Example: Area1 = 21 (3+4+10+4)
- Var: Qty/Total. Example: Area1, Range1 = 0.14 (3/21)
Do you know how could I do that?
Sum(TOTAL <Area> Qty)
Sum(Qty)/Sum(TOTAL <Area> Qty)
View solution in original post