Discussion Board for collaboration on QlikView Layout & Visualizations.
I have a pivot table with 2 dimensions. First one is Date, second one is Product.I would like to show the evolution of Products' Prices starting from 100 (rebased data).
Attached is the table that I would like to get. I have been trying to achieve this using First() function, but no luck...
Many thanks for your help.
Have you tried using set analysis?
Can you attach the QVW? At least for me, it is easier to help working on a sample QVW rather than talking conceptually.