topic Re: Replacing Null values in QlikView

Replacing Null values

praveenkumar_s — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to replace the EmployeeID null value as 0. what can i do to get that as i join three table containing EmployeeID

sushil353 — Mon, 26 Dec 2016 05:18:28 GMT

if you want to change the null value in the charts

then use expression : alt(EmloyeeID,0)

HTH

Sushil

Mon, 26 Dec 2016 05:22:23 GMT

You can achieve this in two ways either in script or in chart. In chart go to presentation tab change the null value represent from - to 0.

If you want to achieve this in script level check for null value while loading from source change the value there it self.

you can use isnull or coalesce function bro.

Mon, 26 Dec 2016 05:58:58 GMT

Hi Praveen,

Use following at Backend i.e, in scrpting (Ctrl + E)

IF(ISNULL(EmployeeID),0,EmployeeID) AS EmployeeID

tyagishaila — Mon, 26 Dec 2016 07:39:54 GMT

Try it once,

Write in script-

NullAsValue EmployeeID;

SET NullValue='0';