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-1686620122957.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-1686620123061.png

 

Sxbbb_2-1686620122961.png

 

I tried using the code : Check_Time_StartMachine - OverTimeMorning

Result :

Sxbbb_3-1686620123060.png

 

 

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

Sxbbb_4-1686620122956.png

 

 

0 Replies