Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Data Refresh


Hi guys,

I have multiple data files, which gets updated any time, my dashboard is scheduled to refresh on weekly basis, So issue is Last refresh date shows Dashboard refresh date, every week dashboard refresh date gets updated irrespective of data got updated or not. Users gets confused with that, they assume data got updated. Is there any way to show data refresh date in dashboard??

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Try something like this

Test1:

LOAD FileTime() as Time, FileName() as Name

From E:\NewFolder\Data\*.xlsx;

Test2:

LOAD Max(Time) as NewTime Resident Test1;

So, your NewTime field will have the last updated data file. If you show this in the dashboard using a TextObject, users will understand if it is of last week or the latest week.

Hope this helps.

Cheers,

Naresh

View solution in original post

10 Replies
Highlighted
Partner
Partner

You can use ReloadTime().

It will give you the last reloaded time of the dashboard.

Cheers,

Naresh

Highlighted
Partner
Partner

In this case pick your Transaction or Fact QVD create time or get the max transaction time from your available data to show Last Update Date.

Highlighted
Not applicable

ReloadTime() shows dashboard refresh time, i want to show data refresh time

Highlighted
Specialist II
Specialist II

at the end of  your script execution, create a variable to hold the maximum date of the Date Field(on which basis you are confirming the source data is updated or not).

use that variable to display the latest updated data.

Highlighted
Partner
Partner

Hi,

Use two date fields on front end

One date is maximum of Transaction Date(or any other date field in your context), display the same as Till the date and display second date as ReloadTime() which is the date when your Dashboard is reloaded, name it last refreshed. No confusion whatsoever!

HTH

Regards,


Highlighted
Partner
Partner

Try something like this

Test1:

LOAD FileTime() as Time, FileName() as Name

From E:\NewFolder\Data\*.xlsx;

Test2:

LOAD Max(Time) as NewTime Resident Test1;

So, your NewTime field will have the last updated data file. If you show this in the dashboard using a TextObject, users will understand if it is of last week or the latest week.

Hope this helps.

Cheers,

Naresh

View solution in original post

Highlighted
Not applicable

I believe you may have timestamp on your application. If yes, create set analysis expression on UI:

'Last Refresh Time: ' & Max({1}TimestampFieldName)

If you don't have timestamp field in your application or rollover the data to day or week level. write sql statements to get the latest timestamp from your fact table.

Highlighted
Specialist III
Specialist III

Hey there,

Check my solution in the attached file

Regards,

MB

Highlighted
Master
Master

Hi,

Like this

The filetime() function does this nicely.

date(filetime('\\path\tofile\dailydata.csv'),'DD/MM/YYYY hh:mm') as DateModified

Hope this Helps,

PFA,

Hirish

HirisH
“Aspire to Inspire before we Expire!”