Solved: KPI Remove Nulls - Qlik Community

pgalvezt · ‎2020-10-09

Hello,

I need to remove the null values in the KPI Object.

I Have a KPI with this Formula.

Sum({<fec_ini={">=01-01-2019"}>}NetWorkDays(fec_ini,fecha_Fin, $(vNWD)))

Thanks!!

Anil_Babu_Samineni · ‎2020-10-09

Perhaps this

Sum({<fec_ini={">=01-01-2019"}, FieldName_Null = {"=Len(FieldName_Null)>0"}>}NetWorkDays(fec_ini,fecha_Fin, $(vNWD)))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Anil_Babu_Samineni · ‎2020-10-09

Perhaps this

Sum({<fec_ini={">=01-01-2019"}, FieldName_Null = {"=Len(FieldName_Null)>0"}>}NetWorkDays(fec_ini,fecha_Fin, $(vNWD)))

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

pgalvezt · ‎2020-10-09

Perfect !!

Thank You !