Optimising the Kpi LOGIC

[manu1512]

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

[dplr-rn]

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"}

[Anil_Babu_Samineni]

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