Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

dairan73
New Contributor III

Sort the time in the time group

I need help to sort the time (UsedTime) in the time group, for example:

Time Groups:

07:00 to 12:59

13:00 to 18:59

19:00 to 22:59

23:00 to 06:59

2017-04-24 - 001.png

Example: Cod 111 have the total time of 02:45, but 44 minutes need to join the group 13:00 to 18:59 and 2hours and 1 minute to the group 19:00 to 22:59.

Can someone help me?

Thank you.

Tags (1)
11 Replies
MVP
MVP

Re: Sort the time in the time group

You need this in the script or front end? and where are the Time Groups? In another table?

dairan73
New Contributor III

Re: Sort the time in the time group

I prefer in the script.

Time Groups not existis in a table, the user told me.

MVP
MVP

Re: Sort the time in the time group

So these groups can change or are these always going to be the same?

dairan73
New Contributor III

Re: Sort the time in the time group

The groups will always be the same.

dairan73
New Contributor III

Re: Sort the time in the time group

Any idea ?

dairan73
New Contributor III

Re: Sort the time in the time group

Do you know how to do ?

Re: Sort the time in the time group

As per your data what was the output you want to see?

kamielrajaram
Contributor III

Re: Sort the time in the time group

Hi,

Try creating a inline table with your time groups and then use the intervalmatch function to associate times to time groups.

Kind Regards

Kamiel

dairan73
New Contributor III

Re: Sort the time in the time group

I need to look like this:

2017-04-25 - 001.png