how to find out null values and Removing those Values

[madhubabum]

Hi Experts

I am having one Pivot Table, In that one field having value remaining are Zero's

How we can identify the others values in Script Level ? Removing ?

Thanks

Madhu

[jsingh71]

Load

if (Fieldname <> 0,FieldName) as Fieldname

--------

[tresesco]

IsNull() will help find null values. However, some values which are not really null, can be tracked using expression something like: Len(Trim(field))=0. For better understanding read the following blog. NULL handling in QlikView

[mayankraoka]

Hi,

Please find attached PDF will help you.

Regards,

Mayank