12 MR Limitation

[Anonymous]

Dear,

I'm trying to obtain a 12 Months rolling Chart.

It works using a simple formula: RangeSum (above(sum(Unit), 0, 12))

The problem is that I don't have sales every months. The result is that I can't see a 12 Months rolling chart because qlik considers the last 12 months in which there was a sale (for example 16 months).

Can you explain me how can I solve this problem.??

I don't know anymore what I can do!!!... and I have to deliver my project....

Thanks in advance for your support

Lorenzo

[Anil_Babu_Samineni]

Create Master Calendar Generation Script and then use Same formula.

[juraj_misina]

Hello Lorenzo,

you can for example generate missing months, so you'd have a record for all months, although in some months the sum sales would be equal to zero. Then you can turn on displaying zero values in the chart and your calculation would work.

Another option is to create The As-Of Table

Hope this helps.

Juraj

[karthikoffi27se]

Hi Lorenzo,

Please use below formula in calculated dimension field

if(Date#(Date("Yourfield",'MMM YYYY'),'MMM YYYY')>= addmonths(today(),-12), Date#(Date("Yourfield",'MMM YYYY'),'MMM YYYY'))

Many Thanks

Karthik