Displaying data for certain groups

[#1]

Hi all, I'm fairly new to Qlikview and learning my way around.

I'm looking to display the amount of time a certain group takes to process a request.

I have:

1.A create date

2.A create time

3.A complete date

4.A complete time

5.The difference between the end and start date using this formula:

     LOAD *,Interval(([Complete Date]-[Create Date])+([Complete Time] - [Create Time]),'D hh:mm') as Diff;

Each create and completed date are associated with a certain group or approver.

I am looking to display all the requests and the average amount of time of each group/person associated with requests.

Also how much time on average that the entire list of people are taking with requests.

Can anyone give me any suggestions on expressions for charts to do this?

[MarcoWedel]

please post sample data/app

thanks

regards

Marco

[#3]

Hey Marco,

How do I post my QVW here or how can I share this data with you?

Thanks

[buzzy996 · Accepted solution]

clik on reply--on right side there USE ADVANCED EDITOR--clik on that--on bottom ATTACH--clik browse ur file---save.