Discussion board where members can get started with QlikView.
I am quite new to QV and would appreciate assistance. I currently have a pivot table with the following as dimensions:-
My expressions (or what I would like to achieve, rather) are:
- Actual :sum(QtyTotal)
- LY (Last Year): This should be the value of Actual but exactly one year ago
I have arranged my table as in the following (with sample data and dimensions in bold, expressions in italics😞
My question is how do I get the previous year sums to show in the Last Year column? Or would there be another simpler approach?
Thanks in advance.