Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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.