Skip to main content
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 (3)
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