How to get the last updated QVD?

[Anonymous]

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

[its_anandrjs]

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

[ashfaq_haseeb · Accepted solution]

Hi,

Have a look at attached application.

Regards

ASHFAQ

[Anonymous]

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

You are an invaluable asset to the community.

Regards,

Sharma.

[ashfaq_haseeb]

Welcome

Regards

ASHFAQ

[Gysbert_Wassenaar]

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.

[its_anandrjs]

Nice example gysbert

Regards,

Anand

[Anonymous]

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.

[#9]

Hi Gysbert.

Gysbert Wassenaar

This is excellent solution.

Your code is somehow not working.

Can you please check what is the issue.

BR

Harish

[qlikview2015]

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