Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

How to filter when my field sEG have missing value ?

HI All

i have try

=if(sEG='A11',sEG)

it can display those A11 company.

may i know how to change the above expression to list missing value ?

i Try :-

=if(sEG=' ',sEG)

it does not work

paul

1 Solution

Accepted Solutions

Re: How to filter when my field sEG have missing value ?

try,

if(len(trim(sEG))=0,sEG)

3 Replies

Re: How to filter when my field sEG have missing value ?

try,

if(len(trim(sEG))=0,sEG)

vinieme12
Esteemed Contributor II

Re: How to filter when my field sEG have missing value ?

I don't understand one thing here; if sEG is missing/null() then why are you trying to return sEG?? it will always return a null value, return some other field

if(Isnull(sEG), otherfield)

or

if(Isnull(sEG), 1,0)

Can you explain the objective for more clarity?

paulyeo11
Valued Contributor II

Re: How to filter when my field sEG have missing value ?

Thank you it work now.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +659:261804

Community Browser