Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

IF Statement - Chart Help

Afternoon all,

I have a basic straight table which is pulling sales lead information.  This table is an overview of top accounts by value etc.  It should be pulling through the top accounts for a sales person when selected, but it's not.  It's pulling all data!!

I imagine I need to put some sort of IF statement in but struggling to get it to work.  So for example Count(IF(name = ' ',OPPORTUNITY_COUNT) this doesn't work......any advice? 

7 Replies
sunny_talwar

Not sure I understand, would you be able to elaborate with an example?

Not applicable
Author

OK so example:

This salesman has 3 active leads but the straight table states 36!!  It seems to be pulling all the leads for all salesman through.....

Anonymous
Not applicable
Author



count (ONLY { 1} Responsible)

or

Rank (ONLY { 1} Responsible)

vinieme12
Champion III
Champion III

where does it state 36 in the snapshot?

also what is the the condition you are trying with the IF statement?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

On the side

Capture.PNG

Seems like a data model issue to me

vinieme12
Champion III
Champion III

I think the OP is trying to count on a KEY field

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
sunny_talwar

That could be a problem too . Unless they want to do a DISTINCT count