topic Script Vs Set Analysis in QlikView

Script Vs Set Analysis

Wed, 30 Jul 2014 08:35:57 GMT

Hi All,

I have Variables set up in my script

Let vCurrDay= date(today()-1);

Let vPrevDay = date(today()-2);

However when i use the variables in my set analysis, i get no result.

Sum({1<call_date = {$(vCurrDay)}>} calls_offered)

Both my call_date and variables return dates YYYY/MM/DD

Please help

Re: Script Vs Set Analysis

SunilChauhan — Wed, 30 Jul 2014 08:46:07 GMT

use

Let vCurrDay= date(today()-1,'YYYY/MM/DD');

Let vPrevDay = date(today()-2,'YYYY/MM/DD');

then

Sum({1<call_date = {$(vCurrDay)}>} calls_offered)

hope this helps

Re: Script Vs Set Analysis

c_gilbert — Wed, 30 Jul 2014 08:46:17 GMT

Try:

sum ( {$<call_date = {"$(vCurrDay)"} >} calls_offered)

Re: Script Vs Set Analysis

Wed, 30 Jul 2014 08:47:04 GMT

Just in case:

Do you have a call_date that is the same as date(today()-1)?

To test this try an expression like the following on a QlikView table:

if(call_date=date(today()-1),'true')

Re: Script Vs Set Analysis

aveeeeeee7en — Wed, 30 Jul 2014 08:47:18 GMT

Try something like this:

Sum({1<call_date={'$(=(vCurrDay))'}>}calls_offered)

Regards

Aviral Nag

Re: Script Vs Set Analysis

VishalWaghole — Wed, 30 Jul 2014 09:01:54 GMT

Hi Stephen,

Try this,

=Sum({1<call_date={'$(vCurrDay)'}>}calls_offered)

whenever you are using variable inside set analysis it should be in single inverted comma.

Hope this will solve your issue.

-- Regards,

Vishal Waghole

Re: Script Vs Set Analysis

Wed, 30 Jul 2014 09:24:51 GMT

thanks this worked 100's

Re: Script Vs Set Analysis

Anonymous — Wed, 30 Jul 2014 10:21:01 GMT

Hi Stephen,

Try below syntax as well:

=Sum({<Call_Date={"<$(vCurrDay)"}>}Call_Details)

Thanks and Regards,

Nita