topic Timeline graph for production, compared to the previous year. in QlikView

Timeline graph for production, compared to the previous year.

Richard3 — Fri, 11 Nov 2022 10:40:08 GMT

I need to have a timeline graph for example of two years with months and years where the production is seen and another line that shows me the comparison of the production against the previous year, as well as I place it in the image, this is possible in Qlik Sense ?

Re: Timeline graph for production, compared to the previous year.

MarcoWedel — Mon, 14 Nov 2022 11:38:25 GMT

Yes, it's possible.

One solution might be:

using these measure expressions

Sum({$<YearDiff={0}>} Sales) Sum({$<YearDiff={1}>} Sales)

and having created an additional table that introduces a one year offset to the MonthYear values :

tabAsOfMonthYear: LOAD Distinct MonthYear, Date(AddYears(MonthYear,IterNo()-1),'MMM YYYY') as AsOfMonthYear, IterNo()-1 as YearDiff Resident tabSales While IterNo() <= 2;

Re: Timeline graph for production, compared to the previous year.

Richard3 — Thu, 17 Nov 2022 15:34:49 GMT

Sorry, I tried to replicate and it generates a single line for each value, for the sum of "Sum({$<YearDiff={0}>} Sales)" and for "Sum({$<YearDiff={1}>} Sales )", What could be that I am doing wrong?

Re: Timeline graph for production, compared to the previous year.

MarcoWedel — Thu, 17 Nov 2022 18:22:30 GMT

Can you share the relevant parts of what you actually did?