topic Re: how to replace only null values? in QlikView

?

xyz1 — Sun, 14 Apr 2019 11:27:46 GMT

jonathandienst — Mon, 30 Jan 2017 04:48:08 GMT

You can use Alt();

=Sum(Alt([late (mm)], [Total elapsed time])) to replace nulls with the elapsed time values.

Mon, 30 Jan 2017 04:51:13 GMT

Hi Agrim,

In Properties Goto--> Dimensions-> Calculated Dimension

use following Expression as if(Late(mm)=0 and Late(mm)='-','Total elapse time',Late(mm))

jonathandienst — Mon, 30 Jan 2017 05:12:18 GMT

I see you want the zero values converted as well. In that case

=Sum(If(len([late (mm)]) = Or [late (mm)] = 0, [Total elapsed time], [late (mm)]))

I am assuming that the '-' are null values.