Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to compare data with different dates?

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.

0 Replies