topic Re: Count values different of empty in QlikView

Count values different of empty

Fri, 03 Jun 2011 20:52:58 GMT

How can I count all values in an excel collumn different of empty?

Thanks

Count values different of empty

erichshiino — Fri, 03 Jun 2011 21:57:12 GMT

When you load from excel, empty cells will be considered as nulls.

Count(field) should work fine for your case.

Do you have a sample where it doesn't work?

Re: Count values different of empty

Miguel_Angel_Baeyens — Fri, 03 Jun 2011 22:05:44 GMT

Hello Kelly,

Although this will work, in case you know you will find some values in one field empty/null/missing, I'd use flag for them and sum the number of flags in your records in the expression. In my experience, and depending on the model and the data set, this usually performs better

Script:

Table:
LOAD *
     If(Len(Field) = 0, 1, 0) AS NullFlag
FROM Source;

Expression:

Sum(NullFlag)

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica