rolling 12 months problem

[ajaymehtaece]

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

[jyothish8807]

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)

[ajaymehtaece]

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

[jyothish8807]

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 ? 

[ajaymehtaece]

No i dont have any trigger in dashboard