topic Re: Nils % in QlikView

Nils %

bazzaonline — Fri, 10 Oct 2014 12:55:06 GMT

Hello,

I have a field of data containing various results ranging from 0 - 10000, I was to write an expression that calculates the % of nils per month.

EG, count all the 0's in the month and divide by the total number of results.

So 0, 0, 0, 1, 1, 2, 2, 3, 4, 5 would equal 30%.

Thank you

Gysbert_Wassenaar — Fri, 10 Oct 2014 12:58:42 GMT

count( {<SomeField={0}>} SomeField) / count(SomeField)

bazzaonline — Fri, 10 Oct 2014 13:13:55 GMT

Doesn't seem to work??

Fri, 10 Oct 2014 13:15:36 GMT

count( if(SomeField=0), SomeField) / count(SomeField)

Fri, 10 Oct 2014 13:43:18 GMT

TRY THIS

=COUNT({ <F1={'0'}> }F1)/COUNT(F1)

cspencer3 — Fri, 10 Oct 2014 13:59:52 GMT

sum(if(Field=0,1,0)) / count(Field)