topic Re: Displaying data for certain groups in QlikView

Displaying data for certain groups

Mon, 15 Jun 2015 20:06:10 GMT

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 — Mon, 15 Jun 2015 23:23:43 GMT

please post sample data/app

thanks

regards

Marco

Tue, 16 Jun 2015 15:06:40 GMT

Hey Marco,

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

Thanks

buzzy996 — Tue, 16 Jun 2015 15:11:31 GMT

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