Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

counting null values

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

5 Replies
tresesco
MVP
MVP

this?

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

'no data') ) 

Not applicable
Author

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

pennetzdorfer
Creator III
Creator III

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
Specialist
Specialist

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
Master II
Master II

Try this way

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