Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikView forum consolidation is complete. Labels are now required. LEARN ABOUT LABELS
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.