Populate the Value to Null

[dineshm030]

Hi All,

I want to set the value for the NULL. Kindly help me out. For "-", need to set as 4 for CPAPotential field.

Thanks & Regards,

Dinesh Kumar.

[JuanGerardo]

Hi @dineshm030, I recommend to use the Coalesce() function, for example: Coalesce(CPAPotential, 4)

JG

[MayilVahanan]

Hi 

Try like below

Alt(CPAPotential, 4) <-- if CPAPotential is numeric

https://help.qlik.com/en-US/sense/May2021/Subsystems/Hub/Content/Sense_Hub/Scripting/ConditionalFunc...

[JuanGerardo]

@MayilVahanan is right as Coalesce() function is not in QlikView. I didn't notice this is not a Qlik Sense thread 😬.

BTW, in case CPAPotential were not numeric, you could use Match() instead.

JG