Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Try:
sum ( {$<call_date = {"$(vCurrDay)"} >} calls_offered)
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')
Try something like this:
Sum({1<call_date={'$(=(vCurrDay))'}>}calls_offered)
Regards
Aviral Nag
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
thanks this worked 100's
Hi Stephen,
Try below syntax as well:
=Sum({<Call_Date={"<$(vCurrDay)"}>}Call_Details)
Thanks and Regards,
Nita