topic Populate the Value to Null in QlikView

Populate the Value to Null

dineshm030 — Fri, 27 Aug 2021 07:53:38 GMT

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 — Fri, 27 Aug 2021 12:27:19 GMT

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

MayilVahanan — Sat, 28 Aug 2021 00:59:30 GMT

Try like below

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

JuanGerardo — Sat, 28 Aug 2021 09:29:08 GMT

@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.