topic # in Set Expression (Calc) in QlikView

# in Set Expression (Calc)

Sat, 14 Nov 2009 00:27:34 GMT

{$(#=FWeek-100)}

why Cant i just do (Fweek - 100) in my set expression, it doesnt seem to work an an example in help pointed me towards the syntax #=FWeek-100, But Why, whats the significnce of the # and if its just a variable being declared why cant I use x = val = etc

theres nothing in help about # being a special character ?

ColinR

# in Set Expression (Calc)

johnw — Sat, 14 Nov 2009 00:33:26 GMT

You can't just do (FWeek-100) in your set expression because it will be interpreted as a text literal, and you'll be looking for the value '(FWeek-100)', which won't exist. The $(=...) format is a dollar sign expansion, which tells QlikView to actually interpret what you wrote instead of just treating it as a text literal. The # says to interpret the result as a number, which should already be the case if FWeek is a number, so it shouldn't be necessary here. You are not declaring # to be a variable, so you can't use some other name.

# in Set Expression (Calc)

Sat, 14 Nov 2009 18:54:24 GMT

Thanks,

Excellent explanation