topic Re: Date problem in QlikView

Date problem

Wed, 17 Jun 2015 14:39:20 GMT

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

Re: Date problem

robert_mika — Wed, 17 Jun 2015 14:59:29 GMT

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

Feeling Qlikgry?

How To /Missing Manual(17 articles)

Re: Date problem

Wed, 17 Jun 2015 15:03:12 GMT

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

Re: Date problem

robert_mika — Wed, 17 Jun 2015 15:19:16 GMT

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)

Re: Date problem

Thu, 18 Jun 2015 08:06:19 GMT

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!

Re: Date problem

robert_mika — Thu, 18 Jun 2015 08:12:50 GMT

Little bit unclear.

Could you give expected results?

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

Re: Date problem

Thu, 18 Jun 2015 08:20:05 GMT

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

Re: Date problem

robert_mika — Thu, 18 Jun 2015 08:24:30 GMT

Could you copy paste your data?not the screenshoot?

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

Re: Date problem

Thu, 18 Jun 2015 08:36:22 GMT

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

Re: Date problem

robert_mika — Thu, 18 Jun 2015 08:42:00 GMT

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

Feeling Qlikngry?

How To /Missing Manual(17 articles)

Re: Date problem

Thu, 18 Jun 2015 08:53:12 GMT

Re: Date problem

robert_mika — Thu, 18 Jun 2015 17:56:29 GMT

Does this help?

t1:

LOAD

[nom table],

[upload creation date],

[upload creation date]-Peek( [upload creation date]) as Value1

FROM

(biff, embedded labels, table is Sheet1$);

Re: Date problem

Fri, 19 Jun 2015 08:43:12 GMT

Yes it works but still a problem, in my file the creation dates aren't originaly sorted from newest to odlest. So when I sort my datas by the creation date the expression doesn't work and I get empty cases :

Thank you so much for your help robert!

Re: Date problem

robert_mika — Fri, 19 Jun 2015 10:23:49 GMT

Could you send the "real" data?

not sorted.

In meantime try this:

t1:

LOAD

[nom table],

[upload creation date],

[upload creation date]-Peek( [upload creation date]) as Value1

FROM

(biff, embedded labels, table is Sheet1$);

t2:

LOAD

[nom table] as Table,

[upload creation date] as Date,

Value1 as Time

resident t1

Order by [upload creation date]asc

;

drop table t1

Feeling Qlikngry?

How To /Missing Manual(17 articles)

Re: Date problem

Fri, 19 Jun 2015 13:58:15 GMT

Ok I succeded!!

Thx for your preacious help!

Re: Date problem

robert_mika — Fri, 19 Jun 2015 14:03:58 GMT

Great.

Could you mark any of the posts as Answered/Helpful to close the topic,please?