Plotting Year Over Year (YoY) evolution in a line chart

Panri93 — Tue, 24 May 2022 08:18:12 GMT

Hi everyone,

I'm new at Qlik and I'm trying to plot two lines overlapped in the same line chart representing data from the actual and past year.

I have to plot the number of "tickets" opened at certain dates. To do this, I have a field called "opening date" which I'm using as a dimension. The expression I'm using is the following one:

=month([Opening date])& ' ' & year([Opening date])

On the other hand, the measure I'm doing is defined as a simple count:

=COUNT(Ticket)

However, when I plot this I'm just getting the data point belonging to a certain opening date but I'd like to see a continuous time axis. Please, see the screenshot:

As you can see, jul. 2021 and nov. 2021 are depicted but instead I'd like to see july, august, september, october, etc. The lines depicted should be one for the current year and the other one for the past year. They should represent the data according to the opening date.

Thanks in advance

topic Plotting Year Over Year (YoY) evolution in a line chart in App Development

Plotting Year Over Year (YoY) evolution in a line chart