topic Re: Time Buckets in QlikView

Time Buckets

Anonymous — Thu, 08 Jan 2015 09:54:00 GMT

Hi Team,

I need to create the monthwise/teamwise Time buckets in the below manner.

Requests completed

<15 Hours

>15 <24 Hours

>24 Hours

The time calculation from start to end should exclude the weekends.

Need your help to achieve this.

Thanks & Regards

Jeba

Re: Time Buckets

Anonymous — Thu, 08 Jan 2015 10:26:48 GMT

Hi Team,

Any idea about this?

Thanks & Regards

Jeba

Re: Time Buckets

martinpohl — Thu, 08 Jan 2015 12:07:14 GMT

It's not as easy as it looks,

but see attached.

Regards

Re: Time Buckets

Anonymous — Thu, 08 Jan 2015 12:50:41 GMT

Hi Martin,

Thanks a lot for the help.

It worked fine.

I tried to create the count of each bucket by RequestId wise.It should be one always .However could you please help me in the set analysis.Kindly confirm what I am missing in that

Thanks & Regards

Jeba

Re: Time Buckets

martinpohl — Thu, 08 Jan 2015 12:59:43 GMT

count(distinct RequestID)

Re: Time Buckets

Anonymous — Thu, 08 Jan 2015 13:02:23 GMT

Hi Martin,

If I check by team,I want to know the count of Requests closed within 24 hours and 24 to 48 hours etc..

In your file I just added by request Id.

Thanks & Regards

Jeba

Re: Time Buckets

martinpohl — Thu, 08 Jan 2015 13:15:25 GMT

Hello,

see attached.

I need the leading 0 for sort.

Regards

Re: Time Buckets

Anonymous — Thu, 08 Jan 2015 13:20:11 GMT

Hi,

Please create time buckets using networkday function,see below link:

http://community.qlik.com/docs/DOC-5314

Regards

Neetha

Re: Time Buckets

Anonymous — Thu, 08 Jan 2015 13:21:03 GMT

Hi Martin,

You are Great.

It worked and thanks a lot for that.

Thanks & Regards

Jeba

Re: Time Buckets

agomes1971 — Thu, 08 Jan 2015 14:00:44 GMT

Hi,

nice approach!!!

André Gomes