I have this table in Business Objects which is showing the number of Open tickets and closed over the last 13 monthx and the backlog for each month of those 13 months. I'm trying to have the same one in QlikView:
Here are the expressions I created for the Open (new) and Closed. But I can't get my head around how to the backlog:
The [Initial Backlog] counts the number of problem IDs extracted from the query "Open in Period". This query is formed of the following fields:
Open Time (Month/Year)
As explained in an earlier post, the query criteria are the following:
(Close Time is Null, OR Close Time is within the selected month OR the preceding 13 months of that selected month), AND
(Open Time is within the selected month OR the preceding 13 months of that selected month)
I'm sorry that I am not making myself clear enough but this is the maximum I can do to explain. The problem is that I'm not very technical and I've got into this field 4 months only. All I'm doing is self learning before taking it to the next step of a business case to the management.