Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
cbaqir
Specialist
Specialist

Ticket Path Date Format and Calculation

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

2020-10-22_16-17-02.jpg

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

2020-10-22_16-20-04.jpg

 

1 Solution

Accepted Solutions
Kush
MVP
MVP

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

 

View solution in original post

5 Replies
Kush
MVP
MVP

@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.

 

cbaqir
Specialist
Specialist
Author

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.2020-10-22_16-17-02.jpg

cbaqir
Specialist
Specialist
Author

@Kush Any other ideas?

Kush
MVP
MVP

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

 

View solution in original post

cbaqir
Specialist
Specialist
Author

Awesome! You are amazing. Thanks!