Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
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

sinduabi
Contributor
Contributor

Hi,

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

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

Regards,

Sindu

ggallina
Creator III
Creator III

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')