Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
jebamalai
Specialist
Specialist

Time Buckets


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

1 Solution

Accepted Solutions
martinpohl
Partner
Partner

Hello,

see attached.

I need the leading 0 for sort.

Regards

View solution in original post

9 Replies
jebamalai
Specialist
Specialist
Author

Hi Team,

Any idea about this?

Thanks & Regards

Jeba

martinpohl
Partner
Partner

It's not as easy as it looks,

but see attached.

Regards

jebamalai
Specialist
Specialist
Author

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

martinpohl
Partner
Partner

like

count(distinct RequestID)

?

jebamalai
Specialist
Specialist
Author

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

martinpohl
Partner
Partner

Hello,

see attached.

I need the leading 0 for sort.

Regards

neetha_p
Master
Master

Hi,

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

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

Regards

Neetha

jebamalai
Specialist
Specialist
Author

Hi Martin,

You are Great.

It worked and thanks a lot for that.

Thanks & Regards

Jeba

agomes1971
Specialist II
Specialist II

Hi,

nice approach!!!

André Gomes