topic Re: How to ignore empty cells with count function in QlikView

How to ignore empty cells with count function

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi, I have a column that is Won_Job_ID that is empty unless an estimate was scheduled into an actual job. I want to do a Count of the Won_Job_ID column that ignores empty cells so I can just see how many estimates were scheduled into jobs.

Any help is greatly appreciated!

Re: How to ignore empty cells with count function

niclaz79 — Tue, 14 Aug 2018 13:51:24 GMT

Depending on whether your fields are actually empty or contains a 0 or similar, use one of these:

Count(if(not isnull(Won_Job_ID),Won_Job_ID))

Count(if(Won_Job_ID<>0,Won_Job_ID))

Re: How to ignore empty cells with count function

Anonymous — Tue, 14 Aug 2018 13:54:48 GMT

I pasted that in there and it didn't work. It still shows the total rows, not the total rows that aren't blank.

Re: How to ignore empty cells with count function

vishsaggi — Tue, 14 Aug 2018 13:55:06 GMT

Try this?

Count({< Won_Job_ID = {"*"} >} Won_Job_ID)

Count({< Won_Job_ID = {

} >} Won_Job_ID)

Count({< Won_Job_ID = {[=Len(Trim(Won_Job_ID))<>0]} >} Won_Job_ID)

Re: How to ignore empty cells with count function

niclaz79 — Tue, 14 Aug 2018 13:56:40 GMT

Try the one with 0 but replace with ' ' instead to indicate a blank.It all depends on how the data looks which we haven't seen.