Regaring "#" symbol in variable

[#1]

Hi Friends,

I have a variable named vQty=10;

But in application it is used as $(#vQty), can any one kindly let me know the meaning of # symbol in the expression?

Thanks in advance!

Kiruthiga

[Chanty4u · Accepted solution]

Hi ,

below example

if you never used quotes for $(#date) it would not be treated as a string. it would just be a date like this: 2015/12/28 , but when you use quotes (' ') , it is converted to a string like this:'2015/12/28'

$ is used to evaluate the expression in the variable :

Check these articles for deeper insights on $ expansion:

and 

'#' before a variable is used (I have not seen much of use cases) if the variable is meant to be evaluated as numeric value. For dollar ($) you have got references to be followed above, the single line highlight here could be

a dollar expansion is something that is done before the expression (or statement) is evaluated.

Single quotes are used when we compare strings. For better understanding and knowledge, read: QlikView Quoteology

[Anonymous]

Hi Kiruthi,

#, it's used as interpretation function.

• Interpretation functions use the textual value of the input, and convert this to a number.

R/Murali.

[avinashelite]

# is used to convert the Variable text value to Number format

[#5]

Thank you Friends, I appreciate your help!

Kiruthiga

[avinashelite]

mark the correct and helpful answers ...so that it will help for others who have similar question

[#7]

Done,Thank you!