Discussion board where members can get started with QlikView.
I have 150000 helpdesk tickets with open/close dates going back 4 years. What I am looking for are some ideas/advice on how to generate what the daily open case backlog has been.
I can sort of do this with Excel (creating a matrix of date/ticket number and adding up left open tickets by the day) but rapidly bump into the 2 million cell limit.
Solved! Go to Solution.
There are probably some approaches / solutions to your request.
I think your problem might be similar to the problem here, instead of tickets with Open/Close date, the task there was to calculate attendance between StartTime and EndTime:
Hope this helps,
Close - given me some idea's but no cigar. Their ID could be a 'ticket' number but I don't want to see the 'backlog' wrapped over the same time period.
I was thinking more along the lines of putting Date as a Column and then ticket numbers across putting a '1' in the ticket column each day/date the ticket was open. I would then be able to do a sum on the date giving me the total open tickets.
How would I go about auto generating ticket column numbers for existing tickets only?
I think I am missing something on your request, I think the referenced solution should possibly serve you to.
Maybe more like Rob or John suggested here?
Could you maybe post a small example of how you would like your results to be displayed?
The screen shot below is what I would like to see out of it with days/date on the X and a count on the Y. Let me see what I make of the 7069 post.
Have you looked at the samples in the manual / Help file? With the created synthentic key, it not so easy to see what's going on, but you could try to join the tables, maybe using (for the above example):
left join INTERVALMATCH (HOUR)