Need help with loading count query in QV

[#1]

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

[#2]

Are you using which DB connection?

Salesforce custom connector or ?

[#3]

Yes the Salesforce Qlikview connector.

[Anonymous]

you need the GROUP BY Statement in your Query

[Anonymous]

or your try count before LOAD

this is a example

CountShip:

LOAD

COUNT (OrderLineKey) as OrderLineKey

SQL SELECT * FROM Shipments;

Regards