Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Qlikview salesforce query WHERE clause not working

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.

Labels (3)
3 Replies
Highlighted
Partner
Partner

Re: Qlikview salesforce query WHERE clause not working

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

Re: Qlikview salesforce query WHERE clause not working

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 ;

Channa
Highlighted
Digital Support
Digital Support

Re: Qlikview salesforce query WHERE clause not working

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.