topic Re: Count Null values over multiple fields in QlikView

Count Null values over multiple fields

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

Dear Qlikview Experts,

May I know how to count the correct number of rows of null value over multiple fields? For example in the picture below, I want to count the total number of rows if AAA, BBB, CCC and DDD fields contailed Null value, so I shall get 2 in return.

Many Thanks for your help in advance!

I had also attached a sample of qvw for your reference.

Best Regards

QianNing

Re: Count Null values over multiple fields

vinieme12 — Wed, 25 Apr 2018 03:28:25 GMT

Try

=count(aggr(if(Rangesum(if(Len(AAA)=0,1),if(Len(BBB)=0,1),if(Len(CCC)=0,1),if(Len(DDD)=0,1))=4,1),MachineNumber,Date,Time))

Re: Count Null values over multiple fields

s10157754 — Wed, 25 Apr 2018 05:47:45 GMT

Dear Vineeth,

Thank you so much for the solution, it works like a charm! Appreciated a lot! Have a nice day!

Best Regards

QianNing