topic Re: need a advice in QlikView

need a advice

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

Hi all,

I need a advice from you all.

I have a created a logic for KPI ,values are displaying correct but unfortunately sheets has taking very long time to respond .??

Can any one tell me how to deal with this ?

Kind Regards

Manu

Re: need a advice

Anil_Babu_Samineni — Thu, 25 Oct 2018 15:08:31 GMT

May be too many actions and Sheets are created in the sheet?

Re: need a advice

manu1512 — Thu, 25 Oct 2018 15:29:57 GMT

there is no triger in it ...

I am using following KPI .....

=num(

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

Any way to opttimise it
??

KInd Regards

MANU

Re: need a advice

Anil_Babu_Samineni — Thu, 25 Oct 2018 15:52:04 GMT

With this, I don't think so why loading page takes time. But, Still we can write 3 Methods more like?

Method-(i)

num(count({<Equipment_isSMA_Upgrade_Eligible={1},

Temp_isEquipmentNoContract={0},

Is_Deleted={'N'},Flag ={1},

Mod_EquipmentStartDate = {"=Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date<=Year_MaxDate"}>+

<Mod_EquipmentStartDate = {"=Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date>=Year_MaxDate"}>} DISTINCT Equipment_Id))

Method-(ii)

num(

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

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

Method-(iii)

num(

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

(Mod_EquipmentStartDate<=Year_MaxDate and Valid_From_Date>=Year_MaxDate), Equipment_Id)))

Re: need a advice

Siva_Sankar — Fri, 26 Oct 2018 00:59:20 GMT

Hi Manu,

Is this the calculation causing performance issue? Can you try deleting the object and check to confirm whether the issue is because of the kpi?

Re: need a advice

manu1512 — Fri, 26 Oct 2018 06:18:43 GMT

Hi Siva,

Yes this is because of Kpi.I have already tried by deleting object