naming of the fields in the select

[davdiste]

Hello,

Why do I have close the names of the fields or tables in quotes (eg `field1`) in the select for the correct operation scripts?

If I want to insert a join in a select, I have to keep the quotes (eg `field1`)?

thx!

[alexandros17]

quotes are not necessary

[hic]

You need quotes if the field name contains a space character or some other special character, but not otherwise.

And you should (usually) not insert a join in the SELECT... See more on http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join

HIC

[SunilChauhan]

we are providing '' are used when we have some space between Names of Table like  'Total Inventory'

we can also use this as [Total Inventory].

if you dont want then u can rename it also

like

'Filed1' as Field1

hope this is what you want

[davdiste]

thanks to everyone

[MK_QSL]

Load 

  [Customer Name],

  "Customer Name" as "Customer Name2",

  Sales

Inline

[

  Customer Name, Sales

  A, 100

  B, 200

];

We can use either double quotes or square brackets while naming any fields in QlikView if the field is having space.