topic null handling in QlikView

null handling

Wed, 06 Feb 2013 05:37:40 GMT

Hi all,

How to supress nulls in a particular field

sujeetsingh — Wed, 06 Feb 2013 05:56:36 GMT

hi,

go to following link it will clear your stuff with NULLS

Wed, 06 Feb 2013 06:00:05 GMT

try this

Load

field1,

field2

from table1 where not IsNull(field1) ;

**********************************************************************

some options on the presentation tab , "supress zero values".

if you want to hide the row in condition of only one expression, I think you could use something like

=if (column(MYEXPRESSIONCOLUMN) = 0,

//or if(isNULL(column(MYEXPRESSION)), ??

YOUREXPRESSION

)

er_mohit — Wed, 06 Feb 2013 06:24:09 GMT

if using pivot table then for supress null value in particular fields then

see the image