topic Re: 12 MR Limitation in QlikView

12 MR Limitation

Anonymous — Mon, 15 Jan 2018 14:10:22 GMT

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

Re: 12 MR Limitation

Anil_Babu_Samineni — Mon, 15 Jan 2018 14:16:00 GMT

Create Master Calendar Generation Script and then use Same formula.

Re: 12 MR Limitation

juraj_misina — Mon, 15 Jan 2018 14:19:27 GMT

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

Re: 12 MR Limitation

karthikoffi27se — Tue, 23 Jan 2018 12:09:05 GMT

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