topic Tickets reaching 5 days in QlikView

Tickets reaching 5 days

Thu, 21 Jan 2016 09:12:14 GMT

Hello All,

I need to calculate the amount of tickets which are still after 5 days.

Can it be done by using set analysis?

Thanks,

Hasvine

Re: Tickets reaching 5 days

miguelbraga — Thu, 21 Jan 2016 09:15:55 GMT

Hey Hasvine

Can you please share with us na exemple of what you want to do? Not sure I understood your issue.

Regards,

Re: Tickets reaching 5 days

Thu, 21 Jan 2016 09:24:23 GMT

Hi Miguel,

Actually, I have a calculate how many tickets have not been closed after the 5 days of work.

Example:

Ticket_num Date_created

1 05/01/2016

2 10/01/2016

3 20/01/2016

4 19/01/2016

5 15/01/2016

6 12/01/2016

I need an expression to calculate how many tickets have exceeded the 5 day on a daily basis.

Any idea...

Many Thanks,

Hasvine

Re: Tickets reaching 5 days

MK_QSL — Thu, 21 Jan 2016 09:26:02 GMT

May be something like below...

SUM({<TicketNo = {"=(Date(Today()) - TicketDate>=5"}>}Amount)

or If you don't want to change script..

use directly below expression

=COUNT({<Ticket_num = {"=Date(Today())- Date_created >=5"}>}DISTINCT Ticket_num)

Re: Tickets reaching 5 days

MK_QSL — Thu, 21 Jan 2016 09:29:03 GMT

Create a Flag in your Script..

Date(Today())- Date_created as Flag

Now use below expression

=COUNT({<Flag = {">=5"}>}DISTINCT Ticket_num)

Re: Tickets reaching 5 days

Anonymous — Thu, 21 Jan 2016 09:47:01 GMT

may be something like this?

=count({<TicketDate=,Status={'Still'}, TicketDate={'>=$(=Date(max(TicketDate)-5,'DateFormat'))<=$(=date(max(TicketDate),'DateFormat'))>} distinct TicketID)

Make Sure DateFormat should be same as TicketDate Format

Re: Tickets reaching 5 days

Fri, 22 Jan 2016 05:18:24 GMT

Thank you. It works. 🙂