Date analyze

Wed, 05 Oct 2011 11:51:39 GMT

Hello!

I have QV-application with info about Service Desk work.

I need

1) table with next fields: "Assignee", "Count of incidents resolved during 1 day", "Count of incidents resolved during 1 week", 1 month, etc.

2) additional table with info about percentage.

3) table with info about average time of resolving for each of fields

So there are 2 dates for each incident: Reported_time and Resolved_time. And time of resolving process = Resolved_time - Reported_time.

My problem is

I do not understand how to work correctly with such operation as "Resolved_time - Reported_time" or "if (Resolved_time - Reported_time) >0 and (Resolved_time - Reported_time)<1), count (Incident_ID)" during the loading or how to make it as condition in expression (in table)

For example xls are attached. One is real data I have (Resolved_time is

[Resolved.TIME]

- Reported_time is

[Reported Date+]

And another is about my tasks.

Thanks a lot for your help!

Re: Date analyze

Thu, 06 Oct 2011 20:24:52 GMT

i don't understand very well what you need, but is it something like this?

topic Re: Date analyze in QlikView

Date analyze

Re: Date analyze