FileTime help

Anonymous — Mon, 18 May 2015 21:55:24 GMT

I am pulling in data from an Excel file on a Sharpoint.

In QV I am doing an incremental load as the Excel file will have that days data and I need to build history.

I need to capture a time (during the load) when the file is put on the SharePoint so I can configure a Traffic Light Gauge based on the time the file is loaded to the SharePoint.

<12:00= Green

>12:01 & <2:00 = yellow

>2:01 = Red

I have tried FileTime, but it updates the entire FileTime column to the current Load Time.

Is there a way for it to retain the FileTime if there is data already in that field and only update the FileTime if the FileTime field is blank for that record?

Dan

Here is an example of what I need:

DATE	DIFFERENCE	FileTime
4/4/15	$0.00	4/4/2015 14:05	New FileTime
4/4/15	$0.00	4/4/2015 14:05
4/4/15	$0.00	4/4/2015 14:05
4/4/15	$0.00	4/4/2015 14:05
4/4/15	$5,954,275.15	4/4/2015 14:05
4/4/15	$4,954,275.15	4/4/2015 14:05
4/3/15	$6,954,275.15	4/3/2015 18:00	retain old filetime
4/3/15	$0.00	4/3/2015 18:00
4/3/15	$0.00	4/3/2015 18:00
4/3/15	$0.00	4/3/2015 18:00
4/3/15	$0.00	4/3/2015 18:00
4/2/15	$0.00	4/2/2015 13:00
4/2/15	$0.00	4/2/2015 13:00
4/2/15	$0.00	4/2/2015 13:00
4/2/15	$0.00	4/2/2015 13:00
4/2/15	$0.00	4/2/2015 13:00
4/1/15	$1.00	4/2/2015 12:00
4/1/15	$2.00	4/2/2015 12:00
4/1/15	$3.00	4/2/2015 12:00
4/1/15	$4.00	4/2/2015 12:00
4/1/15	$5.00	4/2/2015 12:00
4/1/15	$6.00	4/2/2015 12:00

Re: FileTime help

Anonymous — Tue, 19 May 2015 15:36:26 GMT

Issue figured out

Re: FileTime help

koresaket — Wed, 04 Nov 2015 07:21:04 GMT

Hey Dan,

Even I need to retrieve the file update timestamp from an excel placed on a SharePoint. FileTime() is not working for me. How did you achieve this?

Thanks,

Saket.

Re: FileTime help

Anonymous — Fri, 11 Dec 2015 15:21:49 GMT

Saket,

I was not able to pull the timestamp from the Sharepoint based on when the Excel is placed on the SP. What I ended up doing it making a timestamp field within the Excel and used that as my my Timestamp.

topic Re: FileTime help in QlikView

FileTime help

Re: FileTime help

Re: FileTime help

Re: FileTime help