Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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:
=Count(
TOTAL <ProblemCanonicalDateMonthYear>
{<
ProblemCanonicalDateMonthYear={
'>=$(=date(AddMonths(ProblemCanonicalDateMonthYear,-12),'MMM-YYYY'))<=$(=date(ProblemCanonicalDateMonthYear,'MMM-YYYY'))'
},
PRDateType={'PROpenDate'}
>}
ID
)
=Count(
TOTAL <ProblemCanonicalDateMonthYear>
{<
ProblemCanonicalDateMonthYear={
'>=$(=date(AddMonths(ProblemCanonicalDateMonthYear,-12),'MMM-YYYY'))<=$(=date(ProblemCanonicalDateMonthYear,'MMM-YYYY'))'
},
PRDateType={'PRCloseDate'}
>}
ID
)
I've read multiple articles and discussions but I failed to apply a logic behind calculating the backlog historically.
Kindly help me get this done.
Hi,
Looking into it.
but what is the logic for initial backlog?
for example how did we arrive at 44 Backlog for 2015/06
The [Initial Backlog] counts the number of problem IDs extracted from the query "Open in Period". This query is formed of the following fields:
As explained in an earlier post, the query criteria are the following:
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.