topic Re: Optimising the Kpi LOGIC in QlikView

Optimising the Kpi LOGIC

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

Hi all,

I am using the following logic for KPI .But it seems very heavy and takes so much time?

Pls help me to optimise it

(count({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'N'},Flag ={1}>}distinct if(Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date<=Year_MaxDate, Equipment_Id))

+count({<Equipment_isSMA_Upgrade_Eligible={1},Temp_isEquipmentNoContract={0},Is_Deleted={'Y'},Flag ={1}>}distinct if(Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date>=Year_MaxDate, Equipment_Id)))

Re: Optimising the Kpi LOGIC

dplr-rn — Fri, 26 Oct 2018 19:30:28 GMT

Issue must be the if statement.

trying setting flags for those conditions and use that in set analysis

or use something like below

PrimaryKey= {"=YearField1>=YearField2"}*{"=YearType1<=Yearfield3"}

Re: Optimising the Kpi LOGIC

Anil_Babu_Samineni — Sat, 27 Oct 2018 03:32:21 GMT

Is that the same? https://community.qlik.com/message/1563532