Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

hsm12345
New Contributor

show updated QVD date and time

Hi all,

I am interested in how to display the date and time of my QVD.

Once the date and time is displayed in the application, I am interested showing the QVD updated date and time

Ex: The QVD was created on 06/01/2012 at 13:00

The QVD was updated on 06/05/12 at 08:30

The date and time on my application should be 06/05/12 08:30.

Thanks in advance for your help.

4 Replies
rvsilvestre
Contributor III

Re: show updated QVD date and time

Hi,

Put this two functions in load .

load

now() as DateCreated,

filetime( ) as DateUpdated,

....


hsm12345
New Contributor

Re: show updated QVD date and time

ALLDATAV3:

LOAD Company,

Population

FROM

(ooxml, embedded labels, table is test)

The above is my load statement. I am wondering where in this load statement should in add the 2 functions you recommended? Thanks.

now() as DateCreated,

filetime( ) as DateUpdated,

rvsilvestre
Contributor III

Re: show updated QVD date and time

LOAD

now() as DateCreated,

filetime( ) as DateUpdated,

Company,

Population

FROM

...

jason_michaelid
Honored Contributor II

Re: show updated QVD date and time

I think they're the wrong way round aren't they? Maybe:

LOAD

FileTime() as DateCreated,

Now( ) as DateUpdated,

Company,

Population

 

FROM

...

However! You may find that Now() slows down your load time considerably as it is evaluated every second. This also means that if your table takes longer than a second to load you will get differing values. Maybe use a variable at the end of the table load

Let vUpdate = Now();

Now() is only invoked once then. Or else look at the other qvd file functions in the reference manual - there are many of them!

Hope this helps,

Jason

Community Browser