Discussion Board for collaboration related to Creating Analytics for QlikView.
I want to know if this is possible with a Set Analysis to make an expression giving the previous month when the field month is a dimension of my chart ?
Here the Set Modifier would be dynamic and specific for each months ?
Solving this problem would help me to calculate the variation between months.
I don't want to modify the model with the script by placing the value of the previous month on each corresponding row.
Is there somebody who have a solution for this ?
PS : I attached an application trying to illustrate my problem
Go to Solution.
Use before() function.
Hope it helps
Hi pretty cool what you did here. but what if I want to have the variance result in a line chart? I tried to change this to a bar chart, but it when I do this change all the information goes blank.
Thanks and best regards,