counting null values

[#1]

Hi,

i am using htis expression in a chart to show me where i have missing data..

if(isnull(max({<LedgerType={Actual}>}[Issue Date])),

          'no data')

How can i use it in a text box to show me the number of occurences where i have no data?

Thanks

[tresesco]

this?

Count (if(isnull(max({<LedgerType={Actual}>}[Issue Date])),

'no data') ) 

[#3]

Hi, no that doesnt work. that was the first thing i tried.

[pennetzdorfer]

I can recommend the following resources on NULL values:

NULL – The Invisible Nothing

NULL handling in QlikView

I'm pretty sure you'll find a solution in there ...

Regards,

Florian

[khadeer]

Hi,

Replace nulls with some character like replace(isnull(ur requirment),'XXX') as Null_Flag

and use count(Null_Flag) ....

I hope it will works.

Regards,

Khadeer

[er_mohit]

Try this way

max(if(LedgerType='Actual',[Issue Date],'no data'))