Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
rustyfishbones
Master II
Master II

How to Calculate Start Time -End Time for each Pallet ID

Hi All,

Please see the attached, I have a field called PalletNumber and I want to calculate how much time it took to pick the cases for each pallet ID

1 Solution

Accepted Solutions
gopalopsharma
Creator
Creator

Hello Alan,

Follow the steps below:

1. Add a straight table

2. Add PalleteNumber as dimension

3. Write the expression below:

minute(num(max([End Time]))-num(min([Start Time])))

This will give results in minutes

If you wish, you can create two expressions for Max([Time Period]) and Min([Time Period]) and then in third you just need to write column(2)-column(1)...

Hope this helps.

View solution in original post

2 Replies
gopalopsharma
Creator
Creator

Hello Alan,

Follow the steps below:

1. Add a straight table

2. Add PalleteNumber as dimension

3. Write the expression below:

minute(num(max([End Time]))-num(min([Start Time])))

This will give results in minutes

If you wish, you can create two expressions for Max([Time Period]) and Min([Time Period]) and then in third you just need to write column(2)-column(1)...

Hope this helps.

rustyfishbones
Master II
Master II
Author

Thanks Gopal