Hi All,
I have a table in QlikView with three columns
Week, GrossPremium, NetPremium
W1, 1000, 800
W2, 2000, 1500
I need to produce output in a QlikView pivot chat as below, which shows the movement of premium week on week
Week W1 W2
Value Movement Value Movement
Gross Premium 1000 - 2000 1000
Net Premium 800 - 1800 700
Movement is calculated by subtracting the current week numbers with previous week numbers. I have used a valuelist fucntion to create additional dimension with values 'Value' and 'Movement'. I don't want to create these columns in my script for performance issues (i have a huge table with a number of variables to compare (not just gross & net premium).
Attached is the sample QVW.
Could you please help me with this?
Thanks in advance.
Murali