Linechart with two lines for different timespans

Panos — Sun, 08 May 2022 20:32:34 GMT

Hello everyone.

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

Re: Linechart with two lines for different timespans

IamAlbinAntony — Mon, 09 May 2022 05:44:03 GMT

Use Combo chart and use set analysis for each measure. Change bar into lines

topic Re: Linechart with two lines for different timespans in App Development

Linechart with two lines for different timespans

Re: Linechart with two lines for different timespans