topic Re: Data Refresh in QlikView

Data Refresh

Tue, 19 Jan 2016 07:05:17 GMT

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

Re: Data Refresh

NareshGuntur — Tue, 19 Jan 2016 08:19:34 GMT

You can use ReloadTime().

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

Cheers,

Naresh

Re: Data Refresh

manojkulkarni — Tue, 19 Jan 2016 08:30:19 GMT

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.

Re: Data Refresh

Tue, 19 Jan 2016 09:15:31 GMT

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

Re: Data Refresh

PradeepReddy — Tue, 19 Jan 2016 09:40:59 GMT

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.

Re: Data Refresh

mithilesh17 — Tue, 19 Jan 2016 10:11:17 GMT

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,

Re: Data Refresh

NareshGuntur — Tue, 19 Jan 2016 13:02:55 GMT

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

Re: Data Refresh

Wed, 20 Jan 2016 14:40:23 GMT

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.

Re: Data Refresh

miguelbraga — Wed, 20 Jan 2016 14:48:15 GMT

Hey there,

Check my solution in the attached file

Regards,

Re: Data Refresh

HirisH_V7 — Wed, 20 Jan 2016 14:57:45 GMT

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

Re: Data Refresh

Thu, 21 Jan 2016 07:11:25 GMT

any idea how to check multiple correct answer? Thanks a lot guys for different good ideas for this requirement.