Equal to nothing

[nevilledhamsiri]

Dear Friends

How we say in qlik view equal to nothing. Say if a column has some numbers & if we need to say if the cell of that column equal to nothing ,it should be 'nul' otherwise the cell number.

IF( P4<>'NUL',P4)  Is this correct? if we do like this.

Thanks

Neville

[sunny_talwar · Accepted solution]

May be this

If(Len(Trim(P4)) > 0, P4)

[nevilledhamsiri]

Thanks Sunny, It works well!

COLLECTIONS:

LOAD DATE,TYPE, REF_NUMBER, DEB_NUMBER, INSURED, CH_NO, If(Len(Trim(CH_NO)) > 0, 'CH','CASH') AS MODE,

BANK, [V/NO], TOTAL as solde

FROM (ooxml, embedded labels, table is Sheet1);