Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Re: Null Handling

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
Honored Contributor III

Re: Null Handling

Sorry,

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

Highlighted
sinduabi
New Contributor

Re: Null Handling

Hi,

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

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

Regards,

Sindu

ggallina
Contributor III

Re: Null Handling

Hi,

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

Best regards.

sasiparupudi1
Honored Contributor III

Re: Null Handling

Hi

Did you get your answer?

Sasi

Re: Null Handling

try like :

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