Discussion Board for collaboration related to QlikView App Development.
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?
