Comparing two different date periods in a Qlik Chart

AndersGS — Fri, 15 Nov 2024 23:35:53 GMT

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:

We are using QlikView 11.2.

Any ideas?

Thanks,
Anders

Re: Comparing two different date periods in a Qlik Chart

AndersGS — Fri, 20 Nov 2020 11:58:18 GMT

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

topic Comparing two different date periods in a Qlik Chart in QlikView

Comparing two different date periods in a Qlik Chart

Re: Comparing two different date periods in a Qlik Chart