Counting Null

pauledrich — Wed, 18 Sep 2013 17:17:38 GMT

Hi There,

I have read various articles about Null and the white paper from Hic as well as the blog post from QlikView Addict: Handling Nulls in QlikView.

I want to count the number of Branches whom have not carried out any changes to Euro currency rates today "ODate" is an override date field.

I have this expression which is returning the branches that have and the number of times, where am I going wrong?

Any suggestions appreciated.

Count({$<CurrencyCode={EUR},BranchCode ={"=isnull(SellOverideReason)"},ODate={'$(=Date(today(),'DD/MM/YYYY'))'}>}ODate)

Re: Counting Null

CELAMBARASAN — Wed, 18 Sep 2013 17:36:08 GMT

I didn't know about the database design.

May be you can try with this

Count({$<CurrencyCode={EUR},SellOverideReason-={'*'},ODate={'$(=Date(today(),'DD/MM/YYYY'))'}>}ODate)