Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
Kushal_Chawda

try,

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

View solution in original post

3 Replies
Kushal_Chawda

try,

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

vinieme12
Champion III
Champion III

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?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
paulyeo11
Master
Master
Author

Thank you it work now.

Paul Yeo

DIrector

TDS Technology (S) P/L

Whatsapp +659:261804