Qlikview salesforce query WHERE clause not working

[deepakkrish]

Hi All ,

Below query is not working in Qlikview . Connection string is valid and succedded . I don't know why the below condition is not working.

Account:

SELECT Id,
Name,
Strategic_Account__c,
Account_ID__c,
Account__c,

FROM Account WHERE Strategic_Account__c=1;

Please give me your suggestions.

Thanks,

Krish.

[dplr-rn]

try WHERE Strategic_Account__c='1'
alternatively use resident load and filter it

[Channa]

use below

load 

Id,
Name,
Strategic_Account__c,
Account_ID__c,
Account__c,

WHERE Strategic_Account__c=1;

SELECT Id,
Name,
Strategic_Account__c,
Account_ID__c,
Account__c,

FROM Account ;

[Brett_Bleess]

Deepak, did either of the posts help you get what you needed?  If so, do not forget to return to the thread and use the Accept as Solution button to mark the post that worked best for you.  This will give them credit for the help and let other Community Members know what worked best for you.  If you are still working upon things, please leave an update on what you still need.

The only other thing I have is Help link that may be of some additional use:

https://help.qlik.com/en-US/connectors/Subsystems/Salesforce_Connector_help/Content/Connectors_Sales...

Regards,
Brett