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

[PrashantSangle]

try below

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

Regards,

[jimmygohhanjie]

Hi,

Thanks for reply. But it does not work..

It is still showing 'No Data to display'

[PrashantSangle]

do you have data for that period on production? is there any section access over there?

[shansundar]

can you let me know your complete expression. This happens when you use some if conditions or any other additional conditions in your chart which is not having any value for this 6 months period.

Thanks,

Shan S

[olivierrobin]

hello

just a question

what is the type of MTK_MONTH_YEAR ?

if it is consiedered as string, maxstring() returns Sep-17 ....

is it what you want ?

[jimmygohhanjie]

hi,

this is the full expression it is rather confusing.

Round(

(

(Sum({$<MTK_MONTH_YEAR={">$(=date(addmonths(maxstring(MTK_MONTH_YEAR),-6),'MMM-YY')) <=$(=date(maxstring(MTK_MONTH_YEAR),'MMM-YY'))"},MTK_YEAR=, MTK_QTR=, MTK_MONTH=, MTK_WEEK=, MTK_DATE=, DATASOURCE_ID={'DAILY ALLOCATION'},METRIC_LEVEL2_ID-={'Start-Outstanding','Volume In','Incomplete'}>} EFFORT ))

/

(Sum({$<MTK_MONTH_YEAR={">$(=date(addmonths(maxstring(MTK_MONTH_YEAR),-6),'MMM-YY')) <=$(=date(maxstring(MTK_MONTH_YEAR),'MMM-YY'))"},MTK_YEAR=, MTK_QTR=, MTK_MONTH=, MTK_WEEK=, MTK_DATE=,DATASOURCE_ID={'ATTENDANCE'},METRIC_ID={'Mtk Hours Worked'}>} EFFORT )

-sum({$<MTK_MONTH_YEAR={">$(=date(addmonths(maxstring(MTK_MONTH_YEAR),-6),'MMM-YY')) <=$(=date(maxstring(MTK_MONTH_YEAR),'MMM-YY'))"},MTK_YEAR=, MTK_QTR=, MTK_MONTH=, MTK_WEEK=, MTK_DATE=,DATASOURCE_ID={'ATTENDANCE'},METRIC_ID={'Loan'}>}EFFORT))

)

,0.001)

[jimmygohhanjie]

hi,

MTK_Month_year is Date with format of MMM-YY

on my local application, i used MAX().. but in the server i have to use MAXSTRING...

i learnt this as other chart with much simpler set analysis have this issue too.. after i change MAX to MAX string the charts works.

however for this particular expression.. the issue persist. the error is "No Data to Display"

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

[olivierrobin]

that indicates that your set analysis results in no data according to the selection

try to create text boxes with each formula to determine the value they return

[PrashantSangle]

Hi,

looks like you have issue in date interpreting.

As per my understanding here MTK_MONTH_YEAR is interpreting as string that's why max() is not working. If it is in string then you can not use it for range period that's why >= and <= is not working.

modify your script where you have written MTK_MONTH_YEAR field

modify it as

date(date#(MTK_MONTH_YEAR,'MMM-YY'),'MMM-YY') as MTK_MONTH_YEAR

then use same use set analysis which you use in your local machine.

Regards,

Prashant Sangle