Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER 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
Specialist

@Cyberspacedweller  Could you please provide some sample data?