Correct syntax for when SFDC data field name = Qlik script keyword/command?

[#1]

Hi,

I'm working with connecting a dashboard to SFDC data and it all works fine except that I have pull in data for which the field name is "Type".   In QlikSense script editor this is automatically recognized as a command/keyword so it won't load.  I've tried putting the word in various types of quotation marks, parentheses etc but I can't get it to work.

Please help?  What is the correct syntax that would allow me to load in this data also?

thank you!

Pia

[marcus_sommer]

Try it with: "Type" or [Type] or `Type`

- Marcus

[reddy-s]

Hi Pia,

Try using the alias with your first select statement:

Select x,x,x,x,

           Type as `Campaign Type`,

           . . .  . .

Thanks and Regards,

Sangram Reddy.

[#4]

tried all of the above before, no luck

[#5]

if you mean Type as  "Campaign Type" - does not work...

thanks

[marcus_sommer]

Within the qlik sense part are square-brackets working for me - [Date] for example won't be highlighted but even without them worked the load-statement which meant Date wouldn't be handled as keyword or function else simply as field (the syntax interpreter isn't always correct).

- Marcus

[#7]

Hi All,

Thanks for your help.

I feel foolish but I think it actually works just as it is.  Although the word is "flagged" as a script command it actually works.  I just assumed it was not working and tried all kinds of different variations to no avail.

Again, thanks for jumping in to help.