null handling

[#1]

Hi all,

   How to supress nulls in a particular field

[sujeetsingh]

hi,

go to following link it will clear your stuff with NULLS

http://community.qlik.com/docs/DOC-3155

[#3]

hi

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)), ??

0,

YOUREXPRESSION

)

[er_mohit]

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

see the image