Discussion Board for collaboration on QlikView Scripting.
I’ve been playing around with WeekDay(now()) in my incremental loader script for qvds as we’re trying to perform full reloads every Sunday.
Previously I was using:
LET vDayOfWeek = WeekDay(now());
IF $(vDayOfWeek) = 'Sun' THEN
This returns false, however when I use:
IF WeekDay(now()) = 'Sun' THEN
And suddenly it works. I'm just curious as to why this happens, Is there any reason it wouldn't be working as a variable?
Go to Solution.
You need to single quote your variable ref.
If '$(vDayOfWeek)' ...
Take a look at the document log to understand what's going on.
Works perfectly and I hadn't even thought to check the document log to resolve it.