Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

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
Highlighted
MVP
MVP

Re: Aging for business secs ,minutes and hours

what is the expected output?

Highlighted

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

Highlighted
Contributor III
Contributor III

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