# symbol in set analysis

Tue, 04 Aug 2015 15:58:23 GMT

Hi All,

I am working on a qvw file and I see this condition in one of the expression.

(($(#=variablename1)=0) and ($(#=variablename2)=0) and ($(#=variablename3)=0))

I think it is checking for the value in variablename1, 2 and 3 but can somebody explain me the significance of the # in set analysis.Thanks in advance.

Regards,

Max

Re: # symbol in set analysis

swuehl — Tue, 04 Aug 2015 16:03:19 GMT

From the HELP:

For numeric variable expansions, the syntax $( variablename ) will generate a number using the regional decimal separator, i.e. for many countries a decimal comma. Such an expansion should not be used for numbers inside the script since these must use decimal point. Instead the expansion $(# variablename ) should be used. (Note the hash sign). It always yields a valid decimal-point representation of the numeric value of variablename, possibly with exponential notation (for very large/small numbers). If variablename does not exist or does not contain a numeric value, it will be expanded to 0 instead.

Though this is what the HELP states and how it should function, I've encountered some issues with this.

topic # symbol in set analysis in QlikView

# symbol in set analysis

Re: # symbol in set analysis