Date problem

[#1]

Hye I have a question,

I have a file with, on it all the tables of my furm. each night, the tables are updated. This update is resumed in a file on QV.

My question is this :

All the tables are updated one after an other. So the information I have is the date of the end of the update(day/month/year houre/min/sec) of each table. like this :

I want to be able to have the time needed to update each table something like Date1 - Date2= time of update. does someone know a function I could use to do this?

Thx a lot for your help.

Raphael

[robert_mika]

From the data you ave posted what would be your results?

Feeling Qlikgry?

How To /Missing Manual(17 articles)

[#3]

I would like to be able to have for exemple for the first date on the screen 22 sec (2nd date - 1st date)

[robert_mika]

sum(Time)-rangesum (Above(sum(Time),1,1))

In Number change the Format to  Time and then ss

Feeling Qlikgry?

How To /Missing Manual(17 articles)

[#5]

Thanks, I have one question tho (sorry I'm starting on qlikview)..

My goal is to have the time used to upload the table.

The first date on the screen représents the date when the datas started uploading on the first table. the second date représents the date of the end of the loading of the first table and the beggining of the second upload.

So when I said second date - first date it was to find how much time was used for the upload.

Indeed, on the first value, We must find 22sec --> the upload started the 05/09/2014 at 16:25:53 and ended the same day at 16:25:15.

thank you for your time and patience!

[robert_mika]

Little bit unclear.

Could you give expected results?

Or maybe different data set...(with result)

[#7]

Sorry I'm french so I guess It's for that.

I did it on Excel so you can see the result I want on Qlick view.

thx

[robert_mika]

Could you copy paste your data?not the screenshoot?

Is easier when I do not need to retype them into my app..

[#9]

Euuuuuh I do not no how to send files on this (I searched but didn't find how)... it seems I can only send images videos or links

[robert_mika]

Use "advance editor" at the right top hand of this window

Feeling Qlikngry?

How To /Missing Manual(17 articles)