topic Re: using a variable with "quotation marks" inside. in QlikView

using a variable with "quotation marks" inside.

Fri, 18 Jul 2014 10:07:16 GMT

Hi,

I would like to use a field in a Tex Box.

I set the Tex Box as ='$(=[MyField])'

It works only when the content of MyField doesn't have quotation marks inside.

example:

" John Paul Jones " works

" John 'Paul' Jones " doesen't work (Error: Garbage after expression:"......)

How can I do?

thank you very much!

Re: using a variable with "quotation marks" inside.

tresB — Fri, 18 Jul 2014 10:18:19 GMT

Remove single quotes around dollar expansion like:

=$(=[MyField])

Re: using a variable with "quotation marks" inside.

Fri, 18 Jul 2014 10:21:17 GMT

Try this in your

Re: using a variable with "quotation marks" inside.

alexandros17 — Fri, 18 Jul 2014 10:21:24 GMT

Ciao,

in realtà non è un comportamento normale, potresti allegare un esempio?

Grazie e ciao

Alessandro

Re: using a variable with "quotation marks" inside.

simenkg — Fri, 18 Jul 2014 10:45:40 GMT

You can simply use =[MyField] or better yet =Only([MyField])

Re: using a variable with "quotation marks" inside.

Fri, 18 Jul 2014 11:51:22 GMT

It doesn't work, it gives me an error on ","

Re: using a variable with "quotation marks" inside.

Fri, 18 Jul 2014 11:53:05 GMT

Ok but I can't do that, the text that I have to write is in a field in a database (and it changes when I change the selection), so I have to use the name of the field (MyField in the example)

Re: using a variable with "quotation marks" inside.

Fri, 18 Jul 2014 11:54:35 GMT

OMG It works

so can you kindly tell me the difference between using =[MyField] or =Only([MyField])?

Re: using a variable with "quotation marks" inside.

simenkg — Fri, 18 Jul 2014 11:58:53 GMT

On the surface there is no difference. Calling a Field without an aggregate function around implies the use of Only. I just prefer doing things explicit in stead of implicit.

There is however one more reason to use Only and that is that you can use a very powerful tool called set analysis. As you have posted this in New to QlikView, you might not have gotten to that stage yet, but it is well worth learning.