I am trying to compare the trend of a measure over two different timespans.
i.e my data has sales of a product with dates like
order_id
date
products_sold
1
2022/05/01
1
2
2022/05/01
2
3
2022/05/02
1
...
150
2022/05/08
2
I want to compare on a timeline the sales of a product on the days 2022/05/01-2022/05/08 with the sales on the days 2022/03/10-2022/03/17
I would like the timespan start and end to be defined through variables start1, end1, start2, end2.
I think I have to convert (dynamically) the date to days since start1 for the first line and days since start2 for the second line and add a filter on each line on the date field.
In my head it sounds good but I have no idea how to do it in Qlik Sense
