topic Re: Ticket Path Date Format and Calculation in QlikView

Ticket Path Date Format and Calculation

cbaqir — Thu, 22 Oct 2020 23:22:12 GMT

I am trying to mimic a similar but not the same chart I did previously that shows the chronological process path of a ticket:

The first question I have is why my dates aren't displaying correctly in the new version. QVW also attached.

The new version below is a little different in that it's showing phases and one of the phases is 5.2 - Ticket Completion. The secnd question is how can I exclude the date from this phase so it doesn't show on the timeline?

num(if(isnull(ADJ_GOVERNANCE_PHASE_END_DATE and CUR_STATUS_GRP='Closed'),date(today()-ADJ_GOVERNANCE_PHASE_START_DATE),aggr(sum({$<ADJ_GOVERNANCE_PHASE-={'5.2 - Ticket Completion'} >}ADJ_GOVERNANCE_PHASE_TAT),DEFECT_ID,ADJ_GOVERNANCE_PHASE)), '#,##0')

Re: Ticket Path Date Format and Calculation

Kushal_Chawda — Fri, 23 Oct 2020 14:42:37 GMT

@cbaqir not sure I understood completely but Your expression returns number values which you have formatted as Date which is wrong. I have changed what I could think of .see the attached.

Re: Ticket Path Date Format and Calculation

cbaqir — Fri, 23 Oct 2020 15:05:27 GMT

The intent is that the x-axis shows the ADJ_GOVERNANCE_PHASE_START_DATE. The idea is a timeline for a particular ticket like below. This one ticket started in X phase on Y date and lasted Z days. Then it went to the next phase on the next date and lasted AA days. The other complication is that the last phase of 5.2 - Ticket Completion should NOT be in the view.

Re: Ticket Path Date Format and Calculation

cbaqir — Fri, 30 Oct 2020 21:51:15 GMT

@Kushal_Chawda Any other ideas?

Re: Ticket Path Date Format and Calculation

Kushal_Chawda — Sat, 31 Oct 2020 11:55:45 GMT

@cbaqir sorry for the late reply. see the attached. Hope this is what you are looking for

Re: Ticket Path Date Format and Calculation

cbaqir — Mon, 02 Nov 2020 14:25:38 GMT

Awesome! You are amazing. Thanks!