Set analysis not working in Server

[jimmygohhanjie]

hi,

My set analysis works in local computer application. however when deploy into web access. that particular chart has error" No data to display".

Other charts using the same data are working fine

would need some advice on how to revise this set analysis, so server 11 can interpret it.

the purpose is to show last 6 months only. Dimension limit will not do that job.

MTK_MONTH_YEAR={">$(=date(addmonths(maxstring(MTK_MONTH_YEAR),-6),'MMM-YY')) <=$(=date(maxstring(MTK_MONTH_YEAR),'MMM-YY'))"}

this is the potion that is causing the issue..

My desktop application is Qlikview NOV 2017 SR3

The server should be 11.

MTK_MONTH_YEAR

Jul-17

Aug-17

Sep-17

Oct-17

Nov-17

Dec-17

Jan-18

Feb-18

Mar-18

Apr-18

May-18

[jimmygohhanjie]

Hi,

Sorry for the late reply and thanks for your time.

I have been using the below since the begining.

(Date(monthstart(Date#(MTK_DATE,'DDMMMYYYY')), 'MMM-YY'))as MTK_MONTH_YEAR,

I started off using Max(MTK_MONTH_YEAR). it is fine in local application. However it is giving error when deployed in server, it was fixed using MaxString(MTK_MONTH_YEAR). This is for other basic charts.. Hence i used similar approached for this query too.

[olivierrobin]

is your date format identical on local and server ?

[PrashantSangle]

As I have suggested in earlier reply. It is not interpreting as date , it is reading as string, because of that max() not working.

try below in text box

=addmonths(maxstring(MTK_MONTH_YEAR),-1)

Just check is the above expression evaluating or not??

Regards,

[jimmygohhanjie]

good qns.. i will go find out