Line chart on 36 months, with month 0 being the first not null value

[BogdanT18]

Hello,

I need to create a line chart on 36 months with M0 being the first not null value of my measure. This M0 may vary according to the selections that have been made, but when you add them to the graph they should all flow from M0 to M36, even though the M0 for 1st dimension is Jan 2022 and for the second is May 2024. Do you have any suggestions? 

The time measures I have defined are Year and Month at the moment. 

Thank you in advance!

[ogster1974]

You need to create a master calendar to generate values for the potential gaps in your data.

[BogdanT18]

Can you elaborate a little or something...because this doesn't help to much. Thanks! 🙂 

[ogster1974]

your first issue is gaps in your dates this technique will plug the gaps.

https://www.tutorialspoint.com/qlikview/qlikview_master_calendar.htm