Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Tickets reaching 5 days

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

1 Solution

Accepted Solutions

Re: Tickets reaching 5 days

Create a Flag in your Script..

Date(Today())- Date_created as Flag

Now use below expression

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

6 Replies
miguelbraga
Valued Contributor III

Re: Tickets reaching 5 days

Hey Hasvine

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

Regards,

MB

Not applicable

Re: Tickets reaching 5 days

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

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

Create a Flag in your Script..

Date(Today())- Date_created as Flag

Now use below expression

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

balrajahlawat
Esteemed Contributor

Re: Tickets reaching 5 days

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

Not applicable

Re: Tickets reaching 5 days

Thank you. It works. :-)

Community Browser