topic Re: Need help with loading count query in QV in QlikView

Need help with loading count query in QV

Fri, 13 Nov 2015 15:22:39 GMT

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

Fri, 13 Nov 2015 17:01:47 GMT

Are you using which DB connection?

Salesforce custom connector or ?

Fri, 13 Nov 2015 17:51:06 GMT

Yes the Salesforce Qlikview connector.

Anonymous — Fri, 13 Nov 2015 18:55:06 GMT

you need the GROUP BY Statement in your Query

Anonymous — Fri, 13 Nov 2015 19:07:58 GMT

or your try count before LOAD

this is a example

CountShip:

LOAD

COUNT (OrderLineKey) as OrderLineKey

SQL SELECT * FROM Shipments;

Regards