Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

Date analyze

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!

Tags (2)
1 Reply
Not applicable

Re: Date analyze

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