topic Syntax Help on setting variables in QlikView

Syntax Help on setting variables

Fri, 12 Feb 2010 20:23:48 GMT

Can someone help me with syntax. There's something wrong here, but I don't know what it is:

LET vLastWeekLastYr = 52;
LET vCurrentWeekThisYr = 53;

If(
$(vCurrentWeekThisYr) > $(vLastWeekLastYr),
LET vCurrentWeek = $(vLastWeekLastYr),
LET vCurrentWeek = $(vCurrentWeekThisYr)
);

Syntax Help on setting variables

Fri, 12 Feb 2010 20:43:35 GMT

Script IF statements work differently than expression IF statments. Try this:

LET vLastWeekLastYr = 52;

LET vCurrentWeekThisYr = 53;

IF $(vCurrentWeekThisYr) > $(vLastWeekLastYr) THEN

LET vCurrentWeek = $(vLastWeekLastYr);

ELSE

LET vCurrentWeek = $(vCurrentWeekThisYr);

ENDIF

Syntax Help on setting variables

Fri, 12 Feb 2010 20:45:28 GMT

This works too:

LET vLastWeekLastYr = 52;

LET vCurrentWeekThisYr = 53;

LET vCurrentWeek = If(vCurrentWeekThisYr > vLastWeekLastYr, $(vLastWeekLastYr), $(vCurrentWeekThisYr));

Syntax Help on setting variables

Fri, 12 Feb 2010 20:47:23 GMT

Thank you Aaron! 🙂

Syntax Help on setting variables

Fri, 12 Feb 2010 20:48:59 GMT

There are two different if-statements.
One that's used inside a load-statement (and that's the one you are using), and another one that's used as a control statement (this is the one you should be using). The syntax is as follows:

if $(vCurrentWeekThisYr) > $(vLastWeekLastYr) then
LET vCurrentWeek = $(vLastWeekLastYr)
else
LET vCurrentWeek = $(vCurrentWeekThisYr)
end if

Look in the QV help for more examples.

/Fredrik