Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
P
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)