topic Re: Null Handling in QlikView

Null Handling

Wed, 08 Jul 2015 11:36:53 GMT

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

Re: Null Handling

Anonymous — Wed, 08 Jul 2015 11:42:54 GMT

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.

Re: Null Handling

Wed, 08 Jul 2015 11:43:52 GMT

AACTION should reflect as OK

Re: Null Handling

Gabriel — Wed, 08 Jul 2015 11:43:58 GMT

Hi,

This should work

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

Re: Null Handling

Anonymous — Wed, 08 Jul 2015 11:51:27 GMT

So,

maybe is ggod this:

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

Reagrds.

Re: Null Handling

Wed, 08 Jul 2015 11:53:07 GMT

Its Not working

Re: Null Handling

Wed, 08 Jul 2015 11:57:25 GMT

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'

Re: Null Handling

Anonymous — Wed, 08 Jul 2015 12:03:21 GMT

Sorry,

try this:

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

Re: Null Handling

sasiparupudi1 — Wed, 08 Jul 2015 12:08:54 GMT

Please try

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

Re: Null Handling

MayilVahanan — Wed, 08 Jul 2015 12:15:33 GMT

Try like this

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

Re: Null Handling

Wed, 08 Jul 2015 12:18:28 GMT

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.

Re: Null Handling

sasiparupudi1 — Wed, 08 Jul 2015 12:23:59 GMT

Sorry,

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

Re: Null Handling

Anonymous — Wed, 08 Jul 2015 12:24:04 GMT

Hi,

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

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

Regards,

Sindu

Re: Null Handling

Anonymous — Wed, 08 Jul 2015 14:49:22 GMT

Hi,

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

Best regards.

Re: Null Handling

sasiparupudi1 — Tue, 14 Jul 2015 11:23:40 GMT

Did you get your answer?

Sasi

Re: Null Handling

avinashelite — Tue, 14 Jul 2015 11:27:32 GMT

try like :

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