I have data with camps that run on different dates.
I'd like to compare the camps on one graph, with the same timeline/x axis.
After a camp runs I'd like to see how the performance changes over the months.
EG:
Camp: aaaa : Start - Oct 2015
Performance
Oct 2015 : 5
Nov 2015: 15
Dec 2015: 30
Camp: bbbb : Start - Jan 2016
Performance
Jan 2016 : 10
Feb 2016: 20
Mar 2016: 15
What I would want is to set the start date to 0 and the continuing months to be 0+1, and set these two Camps on a single graph of Performance vs time.
Is there a way in qlikview to create a start date variable and then +1 to it for each performance data we have?
I have attached an example, Id like to create a new sheet with the performance set up as described above.