topic WeekDay() created as variable in script in QlikView

WeekDay() created as variable in script

Thu, 14 Jun 2012 02:17:48 GMT

Hey guys,

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?

rwunderlich — Thu, 14 Jun 2012 05:06:56 GMT

You need to single quote your variable ref.

If '$(vDayOfWeek)' ...

Take a look at the document log to understand what's going on.

-Rob

Thu, 14 Jun 2012 06:02:21 GMT

Thanks Rob,

Works perfectly and I hadn't even thought to check the document log to resolve it.