topic Re: single quotes in variable in QlikView

single quotes in variable

manu1512 — Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

Can any one tell me when to use single quotes in set analysis with variable and when not to use them?

Regards

Manu

Chanty4u — Mon, 02 Apr 2018 09:39:18 GMT

read here

shiveshsingh — Mon, 02 Apr 2018 14:48:04 GMT

Single quotes - looking for a direct value like hardcoded..

Double quotes - Search for a string value, may be you can look over the link provided by Chanty

boorgura — Mon, 02 Apr 2018 15:06:52 GMT

Whenever the variable is used within $(), it forces to evaluate the variable. However, if the variable already has stored an evaluated value.

For instance, if the variable vDate is defined as =date(today()).

That means vDate has a value 04/02/2018

If you use '$(vDate)' --> it results in '04/02/2018'

whereas if you use $(vDate) --> it will try to evaluate 04/02/2018 as a mathematical expression (here - division).

Hope that explains!