topic IF Statement - Chart Help in QlikView

IF Statement - Chart Help

Mon, 30 Jan 2017 15:17:47 GMT

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?

Re: IF Statement - Chart Help

sunny_talwar — Mon, 30 Jan 2017 15:21:18 GMT

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

Re: IF Statement - Chart Help

Mon, 30 Jan 2017 15:25:32 GMT

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.....

Re: IF Statement - Chart Help

Anonymous — Mon, 30 Jan 2017 15:30:46 GMT

count (ONLY { 1} Responsible)

Rank (ONLY { 1} Responsible)

Re: IF Statement - Chart Help

vinieme12 — Mon, 30 Jan 2017 15:47:16 GMT

where does it state 36 in the snapshot?

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

Re: IF Statement - Chart Help

sunny_talwar — Mon, 30 Jan 2017 15:49:29 GMT

On the side

Seems like a data model issue to me

Re: IF Statement - Chart Help

vinieme12 — Mon, 30 Jan 2017 15:52:54 GMT

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

Re: IF Statement - Chart Help

sunny_talwar — Mon, 30 Jan 2017 15:55:19 GMT

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