Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

# symbol in set analysis

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

1 Reply
swuehl
MVP
MVP

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.