reg null values count at report level

[#1]

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?

[ashfaq_haseeb]

Hi,

Check this

NULL handling in QlikView

regards

ASHFAQ

[#3]

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

[tresesco]

Have a look at NullCount() as well.