Re: IF Statement - Chart Help - Qlik Community

Report Inappropriate Content · ‎2017-01-30

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?

sunny_talwar · ‎2017-01-30

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

Report Inappropriate Content · ‎2017-01-30

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 · ‎2017-01-30

count (ONLY { 1} Responsible)

or

Rank (ONLY { 1} Responsible)

vinieme12 · ‎2017-01-30

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 · ‎2017-01-30

On the side

Seems like a data model issue to me

vinieme12 · ‎2017-01-30

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 · ‎2017-01-30

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