Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
qvhelpplease
New Contributor II

Aging for business secs ,minutes and hours

Hi all,

I have a requirement of calculating aging for a ticket ,but i want to calculate the aging with in the business days , i want this aging in secs,minutes,hours,days .do any one have idea of how to achieve this .

i am posting the sample data for the requirement.

kush141087gwassenaarrwunderlichswuehlstalwar1mbymrkachhiaimpmaxgrohicsorrakis01cleveranjos

3 Replies

Re: Aging for business secs ,minutes and hours

what is the expected output?

Re: Aging for business secs ,minutes and hours

You could try with the Networkingdays() function , check this threads for more info

Calculate hrs and mins | Qlik Community

want to display time in days, hours, minutes

qvhelpplease
New Contributor II

Re: Aging for business secs ,minutes and hours

the aging calculation should not have the Saturdays and Sundays

lets say i have opened a ticket on Wednesday and ticket resolved on Monday aging will be calculated as    6 days but i want to eliminate sat and sun so it has to be 4 days

Community Browser