Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
Hi,
Have a look at attached application.
Regards
ASHFAQ
Thank you so much Ashfaq, That is what i am looking for,
You are an invaluable asset to the community.
Regards,
Sharma.
Welcome
Regards
ASHFAQ
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.
Nice example gysbert
Regards,
Anand
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.
Hi Gysbert.
This is excellent solution.
Your code is somehow not working.
Can you please check what is the issue.
BR
Harish
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