Script Vs Set Analysis

[#1]

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

[SunilChauhan]

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

[c_gilbert]

Try:

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

[#4]

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

[aveeeeeee7en]

Try something like this:

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

Regards

Aviral Nag

[VishalWaghole]

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

[#7]

thanks this worked 100's

[Anonymous]

Hi Stephen,

Try below syntax as well:

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

Thanks and Regards,

Nita