Count Null values over multiple fields

[s10157754]

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

[vinieme12 · Accepted solution]

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

[s10157754]

Dear Vineeth,

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

Best Regards

QianNing