topic Re: Suppress when value is null in expression in QlikView

Suppress when value is null in expression

bsbernabe — Wed, 25 Nov 2020 16:16:04 GMT

Hello There,

This is my expression below and i want to suppress when value is null in expression how can i ?

Expression

=if ([Days] <= 365,.10,

if ([Days] <= 730,.20,

if ([Days] <= 1095,.30,

if ([Days] <= 7460,.40,

if ([Days] < 1825,.50,

if ([Days] >= 1825,.60))))))*(VALUE))

Best Regards,

Bing

Re: Suppress when value is null in expression

Anil_Babu_Samineni — Wed, 18 Oct 2017 06:05:28 GMT

Perhaps these? And, Just replace with red context to any one from below list

=if ([Days] <= 365,.10,

if ([Days] <= 730,.20,

if ([Days] <= 1095,.30,

if ([Days] <= 7460,.40,

if ([Days] < 1825,.50,

if ([Days] >= 1825,.60))))))* (If(Len(VALUE)>0,VALUE))

Sum({<VALUE -= {' '}>} VALUE)

Sum({$<VALUE -= "=Null()">} VALUE)

If(Not IsNull(VALUE), VALUE)

And even, This works

sum({$<VALUE={"=Len(Trim(VALUE))=0"}>} VALUE)

Re: Suppress when value is null in expression

prma7799 — Wed, 18 Oct 2017 06:26:25 GMT

For this

Sum({$<VALUE -= "=Null()">} VALUE)

And even, This works

sum({$<VALUE={"=Len(Trim(VALUE))=0"}>} VALUE)

Sum({$<VALUE -= {"=Null()"}>} VALUE)

sum({$<VALUE-={"=Len(Trim(VALUE))=0"}>} VALUE)

Re: Suppress when value is null in expression

bsbernabe — Wed, 18 Oct 2017 06:53:09 GMT

Hi Anil,

Thank you so much for your support, your expression is workings

Highly Appreciated.

Best Regards,

Bing

Re: Suppress when value is null in expression

bsbernabe — Wed, 18 Oct 2017 06:54:06 GMT

Hi PM,

Thank for your Support.

Best Regards,

BIng

Re: Suppress when value is null in expression

prma7799 — Wed, 18 Oct 2017 06:57:20 GMT

If this is helpful to you then please mark this reply as helpful it is helpful to others

Re: Suppress when value is null in expression

Anil_Babu_Samineni — Wed, 18 Oct 2017 06:58:09 GMT

I believe First one should work, But in syntax it may shows wing error in red area of null. That is bug (It may work)