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

Hi ,

In this case in script level u can replace null with some character.

like this

if(isnull(false alert),'Null',false alert) AS False Alert.

so in  expression direct we can right ur expression.

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

Thanks,

Ashok.

sasiparupudi1
Master III
Master III

Sorry,

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

Anonymous
Not applicable
Author

Hi,

Might be it din't recogonise it as null, try this

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

Regards,

Sindu

Anonymous
Not applicable
Author

Hi,

maybe is better if we can have sample data because it can be a guessing game.

Best regards.

sasiparupudi1
Master III
Master III

Hi

Did you get your answer?

Sasi

avinashelite

try like :

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