Need to show NULL Values Also

[janardhan]

Hi Friends,

I need to show Null values also in Filter Pane Object. I think Filter Pane object suppresses the Null Values. How to achieve this.

Thanks in Advance

Janardhan

[krishna20]

Hi,

Try Like as below

Data:

LOAD *,

if( isnull(FIELD_NAME) or len(trim(FIELD_NAME))=0 ,1,0) as FlagNull

FROM SOURCE........................................................

Null:

noconcatenate

load *

resident Data

where FlagNull=1;

drop table Data;

[janardhan]

Thanks to all ,

[jagan]

Hi,

Try NullCount()

Regards,

Jagan.

[sasiparupudi1]

Please close the thread by marking the correct answer

[qlikviewwizard]

Hi janardhan

Please mark as Correct Answer to close the thread.