topic Performance issues while creating missing Reference dates in QlikView

Performance issues while creating missing Reference dates

Anonymous — Mon, 20 Mar 2017 07:46:05 GMT

I am using a combination of Canonical Calendar and Generating missing reference dates concept .

we have multiple systems migrated into one new system and I need to show all dates on one time axis.

eg. [Opened Date], [Resolution Date] from New system

[Date Raised],[Resolved Date] from TR System

[Open date UTC],[Resolve date UTC] from IN system

I need to show a trend of outstanding tickets across one common month axis.

Outstanding ticket count as of 28 Feb = all tickets with blank [Resolution Date],[Resolved Date] and [Resolve date UTC] while being opened in Feb or prior to Feb. +

Tickets that were opened in Feb or prior to Feb but resolved after 28 Feb.

Challenge that I am facing is that even if I use set analysis and flags while counting the outstanding tickets I am getting performance issues while clicking the listbox. Numbers get populated correctly but it is slowing down the applications

Re: Performance issues while creating missing Reference dates

Anil_Babu_Samineni — Mon, 20 Mar 2017 07:53:21 GMT

You are the second person i heard about set analysis performance issue. I never face issue / Performance issue while using set analysis. Would you share that expression we can optimize for you to reduce and better work

Re: Performance issues while creating missing Reference dates

Anonymous — Mon, 20 Mar 2017 07:56:23 GMT

(sum(aggr(sum( distinct {<[Referred to CPS]={'Y'},RTC_Status={'ReOpened','To be Assigned','Working'},Month=>}vflag_Elapsed_Time_null_Resolve_dates_Incidents),[TR #],Last13MonthsReferencedateOpened))+

sum(aggr(sum(distinct {<[Referred to CPS]={'Y'},Month=>}vflag_Elapsed_Time_non_null_Resolve_dates_Incidents),[TR #],Last13MonthsReferencedateOpened))
+ sum(aggr(sum ( DISTINCT {<[Referred to CPS]={'Y'},Status={'Open'},Month=>}vflag_Aging_null_Resolve_dates_Incident),[TR #],Last13MonthsReferencedateOpened))) /

(count(DISTINCT{<vflag_Aging_null_Resolve_dates_Incident={'2 months','1 week','2-3 weeks','1 month','>2 months'},Status={'Open'},[Referred to CPS]={'Y'},Month=>}[TR #])+
count(DISTINCT{<vflag_Aging_non_null_Resolve_dates_Incident={'2 months','1 week','2-3 weeks','1 month','>2 months'},[Referred to CPS]={'Y'},Month=>}[TR #])+
count(DISTINCT{<vflag_Aging_null_Resolve_dates_Incident={'2 months','1 week','2-3 weeks','1 month','>2 months'},RTC_Status={'ReOpened','To be Assigned','Working'},[Referred to CPS]={'Y'},Month=>}[TR #]))

Re: Performance issues while creating missing Reference dates

Anonymous — Mon, 20 Mar 2017 07:56:52 GMT

let me know if you need further information