Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying the following to count the # of active members we have as of today (it's on a Salesforce DB using SOQL).
LOAD ActiveMembers;
SQL SELECT count(Member_No__c) ActiveMembers
FROM Members__c where Expiry_Date__c > TODAY and Program__c = 'ABCDEF'
When I try the query on it's own it works fine but when I use QV and I look at the ActiveMembers field it's "-" as if it's null.
Any clue what might be happening?
Thanks in advance,
Amit
Are you using which DB connection?
Salesforce custom connector or ?
Yes the Salesforce Qlikview connector.
you need the GROUP BY Statement in your Query
or your try count before LOAD
this is a example
CountShip:
LOAD
COUNT (OrderLineKey) as OrderLineKey
SQL SELECT * FROM Shipments;
Regards