Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Cyberspacedweller
Contributor
Contributor

Qliksense - Number of customer service tickets expired at month end

Hi all,

I have a line chart showing the number of tickets created vs the number of tickets that have been resolved by the call centre over the last 24 months, using MonthYear as a dimention, and I also need to show how many were expired at the end of each month.

I have [created date], [resolved date] (which may or may not be null depending on whether a ticket has actually been resolved) and a [target date] in the data.  How am I best counting the tickets that are expired at the end of each month?

Thank you

“Any way you look at it, all the information that a person accumulates in a lifetime is just a drop in the bucket.” - B
Labels (1)
1 Reply
sidhiq91
Specialist II
Specialist II

@Cyberspacedweller  Could you please provide some sample data?