topic Re: Set analysis not working in Server in QlikView

Set analysis not working in Server

jimmygohhanjie — Thu, 24 May 2018 07:15:29 GMT

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

Re: Set analysis not working in Server

PrashantSangle — Thu, 24 May 2018 07:23:31 GMT

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,

Re: Set analysis not working in Server

jimmygohhanjie — Thu, 24 May 2018 08:57:17 GMT

Hi,

Thanks for reply. But it does not work..

It is still showing 'No Data to display'

Re: Set analysis not working in Server

PrashantSangle — Thu, 24 May 2018 09:09:11 GMT

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

Re: Set analysis not working in Server

shansundar — Thu, 24 May 2018 09:36:06 GMT

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

Re: Set analysis not working in Server

olivierrobin — Thu, 24 May 2018 09:53:12 GMT

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 ?

Re: Set analysis not working in Server

jimmygohhanjie — Thu, 24 May 2018 10:16:14 GMT

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)

Re: Set analysis not working in Server

jimmygohhanjie — Thu, 24 May 2018 10:20:31 GMT

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'))"}

Re: Set analysis not working in Server

olivierrobin — Thu, 24 May 2018 11:43:46 GMT

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

Re: Set analysis not working in Server

PrashantSangle — Thu, 24 May 2018 11:52:45 GMT

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

Re: Set analysis not working in Server

jimmygohhanjie — Mon, 28 May 2018 07:19:53 GMT

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.

Re: Set analysis not working in Server

olivierrobin — Mon, 28 May 2018 07:43:42 GMT

is your date format identical on local and server ?

Re: Set analysis not working in Server

PrashantSangle — Mon, 28 May 2018 07:47:49 GMT

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,

Re: Set analysis not working in Server

jimmygohhanjie — Mon, 28 May 2018 10:22:50 GMT

good qns.. i will go find out