Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Could a number list instead of dates be an option?
Does anyone have an idea on how to do that?