topic Re: counting null values in QlikView

counting null values

Thu, 01 Aug 2013 09:35:34 GMT

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

tresB — Thu, 01 Aug 2013 09:38:09 GMT

this?

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

'no data') )

Thu, 01 Aug 2013 09:39:42 GMT

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

pennetzdorfer — Thu, 01 Aug 2013 09:59:07 GMT

I can recommend the following resources on NULL values:

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

Regards,

Florian

khadeer — Thu, 01 Aug 2013 10:12:17 GMT

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 — Thu, 01 Aug 2013 10:52:19 GMT

Try this way

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