Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?