topic Re: If statement with variable in QlikView

If statement with variable

timsaddler — Mon, 01 Sep 2014 12:24:14 GMT

Hello
I have this line in my script :-

([AWDT_DATE_CONVERSION] = Today()-3,'Use','No') as FlagYesterday

can i replace Today()-3 with a variable

vYesterDay = Today()-3;

If so, what would be the syntax?

Thanks

Anonymous — Mon, 01 Sep 2014 12:28:13 GMT

just = vYesterDay,'Use','No'

rajeshvaswani77 — Mon, 01 Sep 2014 12:29:12 GMT

Use LET vYesterDay = Today()-3;

alexandros17 — Mon, 01 Sep 2014 12:31:25 GMT

Try with:

LET vYesterDay = Date(Today()-3);

let me know

senpradip007 — Mon, 01 Sep 2014 12:42:17 GMT

Try like:

LET vYesterDay = Date(Today()-3);

Load
If([AWDT_DATE_CONVERSION] = '$(vYesterDay)','Use','No') as FlagYesterday

from <>

timsaddler — Mon, 01 Sep 2014 12:51:22 GMT

Thanks - this answer worked !