Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I'm currenty trying to do a quarter over quarter order volume comparison. (see image below)
The Orders column is a count of all distinct orders for a paticular quarter. I'm having a hard time getting the "Last Quarter" Column to work however.
Ideally the "Last Quarter" column should display order volume for the last quarter.
i.e
I'm really stump so any help would be greatly appriciated.
Thanks in advance,
You could try above(Orders)
or maybe you can use this solution: http://qlikviewnotes.blogspot.com/2012/01/easy-period-analysis-using-qlikview.html
I'm not quite sure how above(orders) would be applicable here, can you elaborate?
Alot of my problems seem to stem from using Quarter as a dimension in the straight table.