topic Re: storing as string in QlikView

storing as string

surajap123 — Mon, 29 Jun 2015 10:34:06 GMT

Hi Experts,

I wanted to store the below part of the expression in a variable-

FIELD={Gross Sales}

I see that it is written like below

LET vGrossSales = 'FIELD={'&Chr(39) & 'Gross Sales' &Chr(39) & '}';

But not like-

LET vGrossSales = 'FIELD={Gross Sales}';

why??

Also, Why we need chr(39) when 'gross sales' already has single cotes?

Re: storing as string

Mon, 29 Jun 2015 10:43:49 GMT

There is no escape characters in qlikview. so we need to use chr() for quotes.

Re: storing as string

Anonymous — Mon, 29 Jun 2015 10:53:28 GMT

Using

LET vGrossSales = 'FIELD={Gross Sales}';

should work fine.

Do you have reason to suspect it does not ?

Re: storing as string

rubenmarin — Mon, 29 Jun 2015 10:57:50 GMT

Hi Suraj, in this expression:

LET vGrossSales = 'FIELD={'&Chr(39) & 'Gross Sales' &Chr(39) & '}';

The bolded parts will be the result of the expression, so "Gross Sales" isn't between single quotes in the result, so you need to add the quotes using CHR(39).

Another way is to use double-single quotes as scape character but can be more confusing than using Chr():

LET vGrossSales = 'FIELD={''Gross Sales''}';

Re: storing as string

surajap123 — Mon, 29 Jun 2015 11:15:17 GMT

Sorry, i didnt clearly understand what you said, could you please explain this statement..

The bolded parts will be the result of the expression, so "Gross Sales" isn't between single quotes in the result--

For more infomation, I will be using the above varaible in my expression like below-

sum({<$(vGrossSales)>}sales)

Re: storing as string

rubenmarin — Mon, 29 Jun 2015 11:24:14 GMT

Hi Suraj, you want your expression result as:

sum({<FIELD={Gross Sales}>}sales)

or:

sum({<FIELD={'Gross Sales'}>}sales)

I think it's the second so to add the single quotes you need to add the Chr(39).

At the end of your first post you said "Also, Why we need chr(39) when 'gross sales' already has single cotes?", I tried to clarify that the result expression wouldn't have single quotes if you avoid the Chr(39), other single quotes in that expression only delimiters strings.

LET vGrossSales = 'FIELD={'&Chr(39) & 'Gross Sales' &Chr(39) & '}';

You can check the result without the Chr(39):

LET vGrossSales = 'FIELD={'& 'Gross Sales' & '}';

Re: storing as string

jonathandienst — Mon, 29 Jun 2015 11:30:05 GMT

There is no escape characters in qlikview. so we need to use chr() for quotes.

That is no longer true - at least from 11.2 SR9. You can escape a single quote by entering it twice:

Set vGrossSales = 'FIELD={''Gross Sales''}';

this results in

FIELD={'Gross Sales'}

Re: storing as string

surajap123 — Mon, 29 Jun 2015 11:59:44 GMT

Hi Martin,

Thanks a lot for the explantion and clarification