I am doing statistics on support tickets and whats to track how many tickets are open on a given date from when a ticket is opened until it is solved.
A somewhat smaller version of the ticket-table is like this:
I’ve come so far as to understand that I have to generate a separate table, where I autogenerate dates between CreatedDate and ResolutionDate and add counter to keep track on how many active tickets there are on a given date, but I am having severe trouble getting it together.
The resulting table I think looks like this:
- both with the purpose of counting number of active tickets, active being defined on a given date if not resolved.
your problem here is pretty simple, because you have all your different dates on the same table, on the same line.
there is aggregation functions on Qlik to help you calculate your measures (number of active tickets etc etc...), so no need for a counter.
the most important here is to create a master calendar using the minimum CreatedDate as a start date and a maximum lastest createddate as End date, to be able to analyse your information using time axis (because most of your dimensions are temporal)
can you attach some data from your tickets table to try to help you more ?