Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Charts & Date Question....

I have a Chart that currently shows the number of Service Desk tickets opened during a year/month and the number of service desk tickets closed within a year/month.  The Chart is setup to display for a rolling 12 months period of time

Each "ticket" has 1 Open Date and 1 Closed Date (no multiple history records for a distinct Ticket Number).

Example:

Ticket 1234 /  Opened: 08/01/2011  /  Closed 11/28/2011

The question I have....

Is there a way to "count" the ticket as open for the 08/2011, 09/2011, and 10/2011 periods within the Chart  with only 1 "record" loaded into Qlikview ?

Thanks for any Assistance you can provide !!

1 Reply
swuehl
MVP
MVP

Probably you could do it like shown in this thread:

http://community.qlik.com/message/7069

Hope this helps,

Stefan