topic Re: Replace null values with 0 through expression in QlikView

Replace null values with 0 through expression

banjo255129 — Thu, 29 Sep 2016 06:00:34 GMT

Want to Replace null values with 0 through expression .

It has two dimensions and for second dimension some values are missing.

Need accumulated value from April to Max month.

Below is the expressions -

=Aggr(Rangesum(Above((Count({<Attr_Flag={1},Year={'$(vMax_Year)'},[Month ID]={'<=$(vMax_MonthID)'}>}DISTINCT [Employee Code])),0,RowNo())),Level,Month)

Month	Level	YTD Attrition Count
Apr	Manager	-
May	Manager	1
Jun	Manager	2
Jul	Manager	5
Aug	Manager	-
Sep	Manager	-5
Oct	Manager	-
Nov	Manager	-
Dec	Manager	-
Jan	Manager	-
Feb	Manager	-
Mar	Manager	-

Re: Replace null values with 0 through expression

Gysbert_Wassenaar — Thu, 29 Sep 2016 16:27:19 GMT

Perhaps like this:

sum(Aggr(Rangesum(Above((Alt(Count({<Attr_Flag={1},Year={'$(vMax_Year)'},[Month ID]={'<=$(vMax_MonthID)'}>}DISTINCT [Employee Code]),0)),0,RowNo())),Level,Month))

Re: Replace null values with 0 through expression

sunny_talwar — Thu, 29 Sep 2016 16:29:09 GMT

May be one of these:

=Sum(Aggr(Rangesum(Above((Count({<Attr_Flag={1},Year={'$(vMax_Year)'},[Month ID]={'<=$(vMax_MonthID)'}>}DISTINCT [Employee Code])),0,RowNo())),Level,Month))

Alt(Aggr(Rangesum(Above((Count({<Attr_Flag={1},Year={'$(vMax_Year)'},[Month ID]={'<=$(vMax_MonthID)'}>}DISTINCT [Employee Code])),0,RowNo())),Level,Month), 0)