Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Not applicable

reg null values count at report level

Hi All,

I have another req... as i have null values at DB level...i would like to get the null records count at report level..

anybody has done earlier on this?

3 Replies
Highlighted

Re: reg null values count at report level

Hi,

Check this

NULL handling in QlikView

regards

ASHFAQ

Not applicable

Re: reg null values count at report level

Hi,

you can use the NullCount function, or another option is to transform your nulls in the script to real data 'Null' for example so they are selectable and easier to investigate

eg if(isnull([Field 1]),'Null',[Field 1]) As [Field 1]

hope that helps

Joe

MVP
MVP

Re: reg null values count at report level

Have a look at NullCount() as well.