topic Re: Makes ` a difference? in QlikView

Makes ` a difference?

qlikconsultant — Thu, 11 Sep 2014 06:46:16 GMT

I have the following load script?

Table1:

Load

`Atribute1`,

`Atribute2`

from

../QVD/DATA/Table1.csv

(txt, utf8, embedded labels, delimiter is '\t', msq);

it works without `. So what effect has ` ?

Re: Makes ` a difference?

alexandros17 — Thu, 11 Sep 2014 06:51:33 GMT

your script with apex will load all equal rows, each one with values

'Atribute1`, `Atribute2`

if you remove apex you will load fields values (the real one contained in table)

Let me know

Re: Makes ` a difference?

qlikconsultant — Thu, 11 Sep 2014 07:06:18 GMT

I both cases the data is loaded correctly. It seems to have no effect.

Re: Makes ` a difference?

tresB — Thu, 11 Sep 2014 07:06:52 GMT

See: QlikView Quoteology

Re: Makes ` a difference?

qlikconsultant — Thu, 16 Oct 2014 08:45:16 GMT

Thanks for the link it's really helpful.

QlikView Quoteology

Double quotes can always be substituted by square brackets or by grave accents.

So it between douple quotes, square brackets or grave accent is no technical difference?

I ask because, if you use the Create Select Statement Wizard, QlikView automatically set the attribute names in grave accent. From my experience there is no benefit in it and i would like to know if I'm correct.

Re: Makes ` a difference?

CELAMBARASAN — Thu, 16 Oct 2014 08:57:12 GMT

Hi Markus,

It will be used for the field names with space in it Eg: `Attribute 1`.

If there is no space in between, no need for that. But QlikView has some less intelligence, so it would have used grave ascent for all the field names.

Re: Makes ` a difference?

tresB — Thu, 16 Oct 2014 09:01:05 GMT

Quotes with Select statement depends on DB, however, with different quotes around field names would not make any difference to qv.

Re: Makes ` a difference?

qlikconsultant — Thu, 16 Oct 2014 09:04:03 GMT

Ok but I could use also double quotes, square brackets or grave accent. It is a design choice?