Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Need help with loading count query in QV

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

4 Replies
Not applicable

Re: Need help with loading count query in QV

Are you using which DB connection?

Salesforce custom connector or ?

Not applicable

Re: Need help with loading count query in QV

Yes the Salesforce Qlikview connector.

alcorona
New Contributor

Re: Need help with loading count query in QV

you need the GROUP BY Statement in your Query

alcorona
New Contributor

Re: Need help with loading count query in QV

or your try count before LOAD

this is a example

CountShip:

LOAD

COUNT (OrderLineKey) as OrderLineKey

SQL SELECT * FROM Shipments;

Regards