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

If condition in Edit Script

Hello,
I need to fetch 2 timestamp for subtraction purpose -start and stop, for which start is from A excel sheet and stop is from B excel.How can I use edit script to perform this operation?

2 Replies
MarcoWedel

please post some example data for both tables as well as your expected result.

thanks

Marco

Athira_K
Contributor III
Contributor III
Author

Hello,
 A.xlsx to have details like startdate,name columns

Athira_K_0-1644476214987.png

B.xlsx have details like enddate,names

Athira_K_1-1644476458211.png

Now I want to subtract enddate from startdate and give results.
How can we use edit script to code this?