Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

Time between two Field

I have a field  'WorkOrderNo' ,'Shift', 'Check_Time_Start' 

Sxbbb_0-1686560720272.png

If Shift = 'Morning' I want Check_Time_Start subtracts with (06:00:00) to get a value between 06:00:00 and Check_Time_Start. 

So I created two fields.

Sxbbb_1-1686560978814.png

Sxbbb_3-1686561026430.png

I tried using the code : Check_Time_StartMachine - OverTimeMorning

Result :

Sxbbb_4-1686561146488.png

 

if the time is between StartOverTimeMorning and OverTimeMornin 9 I want to the value to be 'Check_Time_StartMachine'

Sxbbb_5-1686561547575.png

 

 

0 Replies