difference between #(hash) and $(dollar)

[Anonymous]

Hi,

Could anyone please explain me the difference between # and $ sign before variables and when we use quotes('') with dollar and hash?

For eg: I have an inline fuction

i have min date as vmin=11/11/2013;

load * inline[

no, date

1,11/11/2013

2,10/11/2013

3,12/10/2013

]

where $(min)>'$(#date)'

i m not getting the values if i dont use # .

can anyone please help?

[Anonymous]

check this:

The Magic of Dollar Expansions

Understanding Dollar-sign Expansion - Mastering QlikView [Book]‌

Q-Tip #6 - Those Tricky $-Sign Expansions | Natural Synergies

[Anonymous]

$(Dollar) is nothing but its your $ Expansion, see already shared posting with you.

#(Hash), it might be put before your fieldname but never heard anything like putting # sign before a field

[reddy-s]

Hi Priyanshi,

You use quotes basically when you need a variables as a string. in your 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:

The Magic of Variables

The Magic of Dollar Expansions

[tresesco]

'#' 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

[ValeriyaBartosh]

'#' before a variable is used (I have not seen much of use cases) if the variable is meant to be evaluated as numeric value.

---

Could you please provide any examples?