How to show NULL values with IF function in script

[qlikviewwizard]

Hi All,

How to show NULL values with IF function in script?

Thanks in advance.

[jagan]

Hi,

Use Len() & Trim() it covers both Null and Empty values.

LOAD

*,

If(Len(Trim(SAL)), 0, SAL) AS SAL

FROM DataSource;

Hope this helps you.

Regards,

jagan.

[qlikviewwizard]

Thank you jagan