topic Re: Data won't reload when I refresh manually in QlikView

Data won't reload when I refresh manually

lmcarter — Wed, 25 Nov 2020 16:16:04 GMT

Hi Qlik 🙂

I have seen similar issues but none that answer my use case.

I have a few dashboards that are not updating the data when I refresh manually in the Qlikview application.

Some of my dashboards have updated their data but a couple of the dashboards will show a successful refresh, however the data is not updated.

I appreciate the help!

Re: Data won't reload when I refresh manually

marcus_sommer — Fri, 24 May 2019 08:36:34 GMT

The reason is probably that there no newer data available. This doesn't mean not only the pure rawdata from the database/flatfiles else also all process-steps in the chain. For example if the data aren't loaded from a live-system else from a dump or that the report is a part of a multi-layer process/environment - means that there are maybe n generators/datamodels in a line which perform the whole ETL and the report is just loading from their qvd's or binary.

Therefore take a look on the timestamps of the process-chain if they all are really newer as the reloadtime() of your report.

- Marcus

Re: Data won't reload when I refresh manually

lmcarter — Fri, 24 May 2019 12:40:42 GMT

Hi Marcus,

Thanks for this. I did check the timestamps and they are the most current date.

One of my models has data for the last 12 months.

The only data that is pulling through is data from March 2019 and May 2019. All other months are not appearing in the QV model, however the data in the SAS data library is the full 12 months.

Re: Data won't reload when I refresh manually

marcus_sommer — Fri, 24 May 2019 12:58:03 GMT

There are lots of reasons possible why not all data are loaded within Qlik usually caused from the database which locked records, applies any restrictions (amount of data, access rights, timeouts, ...) or the database-driver which might not be able to handle these records.

- Marcus

Re: Data won't reload when I refresh manually

Josh_Berg_Support — Fri, 24 May 2019 13:12:33 GMT

Have you taken a look at the task log in the QMC to make sure the task is completing without errors? The easiest way to see this is to go to Status > Tasks > select the task > click Show Task Details on the upper-right of the QMC > Task Log. That should show you the most recent run of the task and if it completed successfully. If it failed, it should give you an error, please post that here so we can try to figure it out.

Thanks,

Josh

Qlik Support