How to compare data with different dates?

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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.

topic How to compare data with different dates? in QlikView

How to compare data with different dates?