Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Just what I needed! Thank you