Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
banjo255129
Contributor
Contributor

Replace null values with 0 through expression

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)

MonthLevelYTD Attrition Count
AprManager-
MayManager1
JunManager2
JulManager5
AugManager-
SepManager-5
OctManager-
NovManager-
DecManager-
JanManager-
FebManager-
MarManager-
2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

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))


talk is cheap, supply exceeds demand
sunny_talwar

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))


or


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