Discussion Board for collaboration on QlikView Layout & Visualizations.
I've trying to use pivot table to show information between historical sales, but I use as dimension variable "year" and use dimension "weeks" on columns and expresion sum units sold.
So, I need to show differences per year on same week but I can found the best way but I cant to move this format, so just to use formulas to check this year divided on last year later.
Please give a little help with it.
Thanks a lot.
I attah .qvw file and screen to figured my request.
Go to Solution.
See the attachment. Hope this helps.
If you need to show Year over Year difference, I'd suggest not to use Year as a Dimension, but rather use individual expressions with Set Analysis Conditions for each Year:
Expression1: Current Year
Expression2: Prior Year
Expression 3 Change year over year.
Thanks a lot Sandro!!!!
Can I hide first column? I don't need it.
But second column use the first and answer mi question.
Exactly, the second column uses the first, is the way I solved it, I do not know if there will be another way to do it.