Discussion Board for collaboration related to QlikView App Development.
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?
NULL handling in QlikView
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
Have a look at NullCount() as well.