topic Re: Count records <> 0 in QlikView

Count records <> 0

jorditorras — Thu, 31 May 2018 08:53:34 GMT

Dear Gurus,

I'm trying to calculate a Total of different values excluding Null. In the example below, as there are 3 different Quotations Codes, I'd like to calculate a Total of Quotations = 3.

Company	Quotation Code	Quotations Counter
A01	RMX0242	1
A01	RMX0242	1
A01	RMX0242	1
A01	RMT9942	1
A01	RMT9942	1
A01	XXX4544	1
A01		0
A01		0

Total Quotations Counter = 3

Any idea of how I can get this? If I use the formula Count(Distinct([Quotation Number])) the result is 4 as it is counting also "null" value.

Thanks in advance!

Regards,

Jordi

Re: Count records <> 0

YoussefBelloum — Thu, 31 May 2018 08:56:44 GMT

Hi,

try this:

Count(Distinct {<[Quotation Number]={"=len(trim([Quotation Number]))<>0"}>}[Quotation Number])

Re: Count records <> 0

Anonymous — Thu, 31 May 2018 09:10:06 GMT

try this

Count(Distinct {<[Quotation Counter]={">0"}>} [Quotation Number])

Re: Count records <> 0

jorditorras — Thu, 31 May 2018 09:13:45 GMT

This is working. Thanks Youssef!!

Re: Count records <> 0

YoussefBelloum — Thu, 31 May 2018 09:14:26 GMT

you're welcome

don't forget to close the thread

Re: Count records <> 0

jorditorras — Thu, 31 May 2018 09:15:32 GMT

This solution is also countg nuls. But thanks anyway!!