Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

I want to find the diff time in each row.

Paknanarn23_0-1687329606268.png

I want to subtract the value of the first column in each Wo_KCEPart, what should I do?

5 Replies
Aditya_Chitale
Specialist
Specialist

didn't understand your question. Need more clearity. You want to subtract value of first column from what ? As far as I am seeing, Wo_KCEPart column contains text values.

 

Regards,

Aditya

Paknanarn23
Creator II
Creator II
Author


I want to subtract the times of the DATE TIME fields, for example 2023-06-15 07:06:17 and 2023-06-15 07:06:17 of each Wo_KCEPart.

Paknanarn23_0-1687330822218.png

 

Aditya_Chitale
Specialist
Specialist

Can you provide sample data and expected output ? You can jumble up the numbers if you have security concern.

Regards,

Aditya

Paknanarn23
Creator II
Creator II
Author

Paknanarn23_0-1687331606000.png

For example, I took the value 06/15/2023 08:19 - 06/15/2023 11:15 to get 02:56:11.

Aditya_Chitale
Specialist
Specialist

In your fact  table script,  use this :

"New DateTime" - peek('New DateTime',RowNo(),'data')  as  "DateTime Diff"

Sample Data used:

Aditya_Chitale_0-1687342254475.png

 

Output:

Aditya_Chitale_1-1687342293238.png

 

Hope this is what you were looking for.

 

Regards,

Aditya