topic Re: rolling 12 months problem in QlikView

rolling 12 months problem

ajaymehtaece — Mon, 22 Apr 2019 07:27:42 GMT

Hello everyone,

I have written a query to display 12 months records into the dashboard.formula:

sum( {$<

[Last day of Calendar Date] = {">=$(=Date(MonthEnd(Max([Last day of Calendar Date]),-12-Max(Month([Last day of Calendar Date])))))
<=$(=Date(MonthEnd(Max([Last day of Calendar Date]),-Max(Month([Last day of Calendar Date])))))"}

>} ShipmentabsDiff1) and its working fine on the qlikview desktop.But unfortunitly not working on the server side and on server its returning 24 months data.

Any help will be most appreciated.,

Thanks,

Ajay

Re: rolling 12 months problem

jyothish8807 — Tue, 23 Apr 2019 05:50:15 GMT

Hi Ajay,

Can you try this, it should work if you want to show rolling 12 months data.

Make sure format of [Last day of Calendar Date] and $(=MonthEnd(Addmonts(Max([Last day of Calendar Date]),-12))) are same.

sum( {$<[Last day of Calendar Date] ={">=$(=MonthEnd(Addmonts(Max([Last day of Calendar Date]),-12)))<=$(=MonthEnd(Addmonts(Max([Last day of Calendar Date]),0)))"}>}ShipmentabsDiff1)

Re: rolling 12 months problem

ajaymehtaece — Thu, 25 Apr 2019 03:49:16 GMT

Hi Jyothish,

The formula you mentioned is working fine on the qlikview desktop but not working correctly on the qlikview server

As my qlikview server version is 12.1 and desktop version is 12.2

Re: rolling 12 months problem

jyothish8807 — Thu, 25 Apr 2019 05:47:57 GMT

Hi Ajay,

It is always recommended to keep both server and QV in same version, but can you also check if you have any triggers at Qlikview desktop ?

Re: rolling 12 months problem

ajaymehtaece — Thu, 25 Apr 2019 13:24:46 GMT

No i dont have any trigger in dashboard