Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

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

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

qlik.png

6 Replies

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

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

- Marcus

reddys310
Honored Contributor II

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

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.

Not applicable

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

tried all of the above before, no luck

Not applicable

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

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

thanks

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

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

Highlighted
Not applicable

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

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.