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:
Date
Web CR% 2020
Web 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-17
3,9%
-
2020-11-18
3,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)
this is the (obvious) result in Qlik when using 'Date' as Dimension: