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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2011-11-28 10:52 AM

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 !!

412 Views
0 Likes
1 Reply
swuehl
MVP
MVP
‎2011-11-28 11:08 AM

Probably you could do it like shown in this thread:

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

Hope this helps,

Stefan

183 Views
0 Likes