Line graph issue

[JVET]

Hello. From a table with information for the months of 2020 and 2021, I create a line graph with the information for each month in two measures (two lines, that of 2020 and that of 2021). Obviously, the 2020 line is complete because I have data for all the months, but the one for 2021 I have data until September, but the line of the graph is complete (although without data) until December:

I´m using this:

Sum({<[fecha.autoCalendar.Year]={"$(=Year(today()))"},canal={'0'}, [fecha.autoCalendar.Month]={"<$(=date(month(Today())))"}>} conteo)

¿How can I solve?

Thanks.

[Qlik1_User1]

@JVET , its coming correct as for Year 2021 there is no data for Oct, Nov, Dec. So line is aligned with 0 as value of a measure.

[JVET]

But what I need is for the line to end in September and not continue. Can it be achieved?

[Qlik1_User1]

@JVET Here NULL is getting converted to 0 and its a valid value so not sure if this possible but try to uncheck the "Include null values" in dimension may be that works.

[JVET]

I've already tried it, but it doesn't work. Thank you very much anyway

[tm_burgers]

Have you tried switching the Missing Values dropdown to "Show as Gaps" ?

If the number truly is null() and not 0 this should work!