Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

square brackets vs. quotes

Hi,

In noticed that the general convention is that fields in scripts are placed between square brackets,

So I guess this is the preferred way.

But why, if I open an ODBC SQL table an do a preceding load, does QV shows the files between quotes and not between brackets.

quotes.gif

Is there a way to change my default QV behavior so that it places square brackets in stead of quotes?

Regards,

Gerrit

1 Solution

Accepted Solutions
Not applicable
Author

i think you can't find it in QV app

it's on the other side (database [driver])

check this:

http://www.ironspeed.com/Designer/6.1.0/WebHelp/Part_IX/ODBC_Driver_Support.htm

why is this so important to you?:D

View solution in original post

4 Replies
Not applicable
Author

i think you can't find it in QV app

it's on the other side (database [driver])

check this:

http://www.ironspeed.com/Designer/6.1.0/WebHelp/Part_IX/ODBC_Driver_Support.htm

why is this so important to you?:D

Not applicable
Author

Thanks for your answer.

I now understand the ODBC Driver is responsible for this behavior and I guess it can't be changed.

It is not that important, it is just curiosity.

Regards,

Gerrit

Miguel_Angel_Baeyens

Hi Gerrit,

When fields in QlikView contain spaces or other non ascii or "strange" characters, you need to use double quotes or square brackets on them. That will happen with table names and expression labels as well. If you only need to rename the field, you can use either brackets or quotes, it does not matter.

Hope that helps.

Miguel

Not applicable
Author

Hi Miguel,

Thanks for your reply.

I now understand for Qlikview it doesn't matter if I use brackets or quotes.

I noticed that in the manual and also on this forum brackets are used in general.

My question was triggered by the second message in th following conversation;

http://community.qlik.com/message/238083#238083

When Deepak answered he changed my quotes in the code into brackets.

No big deal just curiosity.

Regards,

Gerrit