topic How to express if cell is not empty? in QlikView

How to express if cell is not empty?

jisephcirspy — Sat, 16 Nov 2024 17:46:09 GMT

So I want to get the cells, which are not empty. I tried

=if(isnull(col),col)

but this is the completely opposite of what I want

I want it like

=if(!isnull(col),col)

Chanty4u — Fri, 27 Nov 2020 09:41:04 GMT

May be this?

If(Len(Trim(Col)) = 0, 1) AS EmptyCol

if(isnull(fieldName),fieldName) as fieldName

if(fieldName=' ',fieldName) as fieldName

if(len(fieldName)=0' ',fieldName) as fieldName

vinni — Fri, 27 Nov 2020 09:45:16 GMT

Hi Jisephcirspy,

You can try below expression:

=If(ISNULL(Col),,Col)

jisephcirspy — Fri, 27 Nov 2020 09:45:30 GMT

no, this doesn't solve the problem 😞

jisephcirspy — Fri, 27 Nov 2020 09:46:57 GMT

it gives me an error...

Chanty4u — Fri, 27 Nov 2020 09:56:15 GMT

try this way

NULLASVALUE *;

IF(IsNull(Col1), 'Not Available', ' ') as [Not Available];