Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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??

Tags (1)
1 Solution

Accepted Solutions
nareshguntur
Valued Contributor

Re: Data Refresh

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

10 Replies
nareshguntur
Valued Contributor

Re: Data Refresh

You can use ReloadTime().

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

Cheers,

Naresh

manojkulkarni
Valued Contributor II

Re: Data Refresh

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.

Not applicable

Re: Data Refresh

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

pradeepreddy
Valued Contributor II

Re: Data Refresh

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.

mithilesh17
Contributor

Re: Data Refresh

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,


nareshguntur
Valued Contributor

Re: Data Refresh

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

Not applicable

Re: Data Refresh

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.

miguelbraga
Valued Contributor III

Re: Data Refresh

Hey there,

Check my solution in the attached file

Regards,

MB

hirishv7
Honored Contributor

Re: Data Refresh

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

Community Browser