Ticket backlog

Tue, 12 Feb 2013 22:47:18 GMT

Hi everyone,

I have trouble ticket data that comes with an OpenedMonth and a ClosedMonth.

TicketNumber	OpenedMonth	ClosedMonth	CountOfTickets
#1	Feb 2012	May 2012	1
#2	Mar 2012	Mar 2012	1
#3	Mar 2012	Apr 2012	1
#4	Apr 2012	Apr 2012	1
#5	Apr 2012	May 2012	1
#6	May 2012	May 2012	1

I want the user to be able to select a Month and Year, and be able to see a backlog of tickets for that month and year.

For example, In Apr 2012, tickets #1 and #5 were available at some point during Apr 2012, but were not resolved until May 2012.

So I want tickets with OpenMonth <= SelectedMonth AND ClosedMonth > SelectedMonth

The SelectedMonth isn't really an OpenMonth or a ClosedMonth.. if I create a list of every month and year, how do I select backlog tickets for selected dates?

I'm guessing a straight or pivot chart with set analysis would be best? What would the expression have to look like?

Thank you!

Re: Ticket backlog

swuehl — Tue, 12 Feb 2013 22:53:52 GMT

I think your issue is quite similar to the use case Henric described in his latest development blog post:

http://community.qlik.com/blogs/qlikviewdesignblog/2013/02/12/reference-dates

Have fun,

Stefan

Re: Ticket backlog

Tue, 19 Feb 2013 20:30:46 GMT

Just what I needed! Thank you

topic Ticket backlog in QlikView

Ticket backlog

Re: Ticket backlog

Re: Ticket backlog