topic Re: Tickets Logged Today in QlikView

Tickets Logged Today

belgarathza — Tue, 02 Apr 2013 09:45:28 GMT

I'm busy creating a dashboard with a viewset which will contain the field "Tickets logged today".I'm battling to get the distinct count for all the Tickets logged for the specifc date. It either gives me all the tickets or it only shows 1. I'm currently using the following formula: "

=Count(DISTINCT([Num]=If([Open Date]=Today(),''))) "

Is there another way of getting the results?

Regards

Terence

Re: Tickets Logged Today

Tue, 02 Apr 2013 09:49:31 GMT

Hi,

you can use this expression

count(distinct if([Open Date]=Today(), TicketID))

Hope this helps.

Regards,

Amay.

Re: Tickets Logged Today

Anonymous — Tue, 02 Apr 2013 09:50:55 GMT

If [Num] is your Ticket ID or something similar you should be able to do something along the lines of:

count({$<[Open Date]={$(=Today())}>} distinct [Num])

Re: Tickets Logged Today

alexandros17 — Tue, 02 Apr 2013 09:53:04 GMT

count({$ <[Open Date]={'$(=today())'}>} DISTINCT Num)

hope it helps

Re: Tickets Logged Today

belgarathza — Tue, 02 Apr 2013 10:13:23 GMT

Hi All

Thank you for the quick responses, I've attached some of the data and a qv file to give more information.

Regards

Terence

Re: Tickets Logged Today

Anonymous — Tue, 02 Apr 2013 10:17:33 GMT

Hi Terence,

You can do this:

=Count(if(Date(floor([Open Date]))=Today(),Num))

But it's easier if you create an OpenDate in your script without timestamp (or just separate the timestamp into another field).

Re: Tickets Logged Today

belgarathza — Tue, 02 Apr 2013 10:33:50 GMT

Hi 🙂

Thank you very much, it works.:-)

I adjusted the formula slightly to assist with the distinct count and it works perfectly.

=Count(Distinct(if(Date(floor([Open Date]))=Today(),Num)))

Regards

Terence