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: 
Not applicable

Null Handling

Hi

For the Below condition

if([False Alert] <> 'Auto Approved' ,'OK','CANCEL') as AACTION,

The Statement doesnot work when False Alert is Blank.

Following are the list of False Alerts

False Alerts:

AUTO APPROVED

APPROVED

REJECTED

It works for AutoApproved , Approved and Rejected. Not working for the blank one

15 Replies
Anonymous
Not applicable
Author

Hi,

what do you mean with not work.

Waht happen when the  False Alert is Blank/Null and what do you expect in this case?

Regards.

Not applicable
Author

AACTION should reflect as OK

Gabriel
Partner - Specialist III
Partner - Specialist III

Hi,

This should work

=if(IsNull(FalseAlerts),'Unknown',if(FalseAlerts <> 'Auto Approved', 'OK','CANCEL'))

Anonymous
Not applicable
Author

So,

maybe is ggod this:

=if(IsNull(FalseAlerts),'',if(FalseAlerts<>'Auto Approved','OK','CANCEL'))

Reagrds.

Not applicable
Author

Hi

Its Not working

Not applicable
Author

Should be

=if(if(IsNull(FalseAlerts),'Unknown', FalseAlerts) <> 'Auto Approved', 'OK','CANCEL')


I.e. replace the NULL value with 'Unknown' and then compare to 'Auto Approved'

Anonymous
Not applicable
Author

Sorry,

try this:

=if(IsNull(FalseAlerts),'Missing',if(FalseAlerts)<>'Auto Approved'),'OK','CANCEL'))

sasiparupudi1
Master III
Master III

Please try

if( (([False Alert] <> 'Auto Approved') or len([False Alert])>0),'OK','CANCEL') as AACTION,

MayilVahanan

Hi

Try like this

=if(Len(Trim(FalseAlerts)) = 0,'UnKnown ',if(FalseAlerts<>'Auto Approved','OK','CANCEL'))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.