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: 
Not applicable

Merge rows excel problem

Hi,

I have an excel table that looks like this :

idstatutdate_startdate_endduree
id1demande ouverte01/05/2010 10:02-
id1demande ouverte02/06/2010 11:13-
id1qualification02/05/2010 13:20-
id2qualif02/05/2010-
id2fermee01/05/2010 12:0003/05/2010 12:2525


and I want to merge cells to obtain duree (duree= date_end-date_start)

I have already tryied with interval function

You can read code with attached file

Yours faithfully

0 Replies