topic Re: How to get the last updated QVD? in QlikView

How to get the last updated QVD?

Anonymous — Mon, 27 Oct 2014 10:29:55 GMT

Hi,

I need to display the last updated QVD date and time at the dashboard . if possible how many rows has been added to that Qvd .

Any help.

Thanks,

Sharma

Re: How to get the last updated QVD?

its_anandrjs — Mon, 27 Oct 2014 10:32:59 GMT

Use ReloadTime() function for this will help you that provide last reload time but if you need the records that loaded latest then use any maximum date updated or if there is primary key then use that also.

Regards

Anand

Re: How to get the last updated QVD?

ashfaq_haseeb — Mon, 27 Oct 2014 10:35:58 GMT

Hi,

Have a look at attached application.

Regards

ASHFAQ

Re: How to get the last updated QVD?

Anonymous — Mon, 27 Oct 2014 10:40:05 GMT

Thank you so much Ashfaq, That is what i am looking for,

You are an invaluable asset to the community.

Regards,

Sharma.

Re: How to get the last updated QVD?

ashfaq_haseeb — Mon, 27 Oct 2014 10:42:41 GMT

Welcome

Regards

ASHFAQ

Re: How to get the last updated QVD?

Gysbert_Wassenaar — Mon, 27 Oct 2014 10:43:40 GMT

Perhaps something like this:

Files:
LOAD '' as Filename
autogenerate(0);

For each vFileName in Filelist ('x:\qvd\*.qvd') 
  concatenate(Files)
  LOAD 
  $(vFileName) as FileName
  FileTime('$(vFileName)') as FileTime
  autogenerate(1)
  ;
Next

Temp:
LOAD 
  FirstSortedValue(FileName, -FileTime) as LastQvdName,
  Max(FileTime) as LastQvdTime
Resident Files;

Let vLastName = peek('LastQvdName');
Let vLastTime = timestamp(peek('LastQvdTime'),'DD-MM-YYYY hh:mm:ss');

I have no idea how many records were updated in your last updated qvd since I have no knowledge of how you create those qvds.

Re: How to get the last updated QVD?

its_anandrjs — Mon, 27 Oct 2014 10:48:09 GMT

Nice example gysbert

Regards,

Anand

Re: How to get the last updated QVD?

Anonymous — Mon, 27 Oct 2014 10:49:16 GMT

Well thanks for the reply,

I have an excel sheet which updates every month and no idea how many rows will be added and these rows should reflect at qvd and these qvds are reflected at dashboard to show the last reload time and how many rows has been added to that particular qvd.

Regards,

Sharma.

Re: Re: How to get the last updated QVD?

Tue, 28 Oct 2014 08:40:10 GMT

Hi Gysbert.

Gysbert Wassenaar

This is excellent solution.

Your code is somehow not working.

Can you please check what is the issue.

Harish

Re: How to get the last updated QVD?

qlikview2015 — Tue, 26 Jul 2016 09:22:21 GMT

Hello Gysbert,

i tried this. But there is an Error Message. Can you help me please ? Is this a script or macro?

Best Regards

Mike Preuss