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

Announcements
Only at Qlik Connect! Guest keynote Jesse Cole shares his secrets for daring to be different. Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
AndersGS
Contributor III
Contributor III

Comparing two different date periods in a Qlik Chart

Hi,

I'm have a chart comparing two different date periods. My data looks like this:

DateWeb CR% 2020Web CR% 2019
2019-11-12-3,4%
2019-11-13-3,2%
2019-11-14-2,1%
2019-11-15-2,2%
2019-11-16-1,3%
2019-11-17-1,6%
2019-11-18-2,7%
2020-11-173,9%-
2020-11-183,5%-

 

The first day of this year is 2020-11-17 and it should compare to the first day of last year, 2019-11-12
and onward. My goal is like below (made in Excel)

ExcelChart.JPG

this is the (obvious) result in Qlik when using 'Date' as Dimension:

QlikChart.JPG

We are using QlikView 11.2.

Any ideas? 

Thanks,
Anders

Labels (2)
1 Reply
AndersGS
Contributor III
Contributor III
Author

Could a number list instead of dates be an option?
Does anyone have an idea on how to do that?

ExcelChart_v2.JPG