Skip to main content

Connectivity & Data Prep

Discussion board where members can learn more about Qlik Sense Data Connectivity.

Skip the ticket, Chat with Qlik Support instead for instant assistance.
Showing results for 
Search instead for 
Did you mean: 

Salesforce Connector Load Script Where

Hello, I am trying to use SFDC connector to load records from an object. I connect fine, but I am trying to filter by a field. LOAD and SELECT work fine and data loads, however when I try to use the  WHERE to filter it does not register as a correct syntax.

If I attempt to do the same concept but the data comes from a spreadsheet, the WHERE registers. 

Do anyone have any ideas?

Thank you,

Labels (1)
1 Reply
Contributor III
Contributor III

WHERE does work with the SFDC connector, but only for non-formula Salesforce fields. Could you please check to see if the field you are trying to filter on is a formula field?