topic Re: Equal to nothing in QlikView

Equal to nothing

nevilledhamsiri — Wed, 07 Mar 2018 18:49:56 GMT

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

Re: Equal to nothing

sunny_talwar — Wed, 07 Mar 2018 18:52:54 GMT

May be this

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

Re: Equal to nothing

nevilledhamsiri — Wed, 07 Mar 2018 19:56:26 GMT

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);