topic Re: How to automatically have latest data in QlikView? in QlikView

How to automatically have latest data in QlikView?

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

Hi all,

I am new to Qlik and I am still exploring the various functions of Qlik.

As my source data is from Excel and it is being updated daily, how do I automatically have the latest data in QlikView?

This is so that every time I open QlikView, the dashboard will show the latest results.

Thank you for the time.

Regards

Re: How to automatically have latest data in QlikView?

kfoudhaily — Sun, 04 Mar 2018 20:23:19 GMT

Hello KN Chai,

I think you need to be mode precise with your question so we can provide the most convenient answer to you.

Generally, to be able to show the latest data in a table or a text box you will have to use set analysis;

for example, to show the latest sum of sales you have to apply the following expression:

=sum({$<Year={'$(vMaxYear)'}>} sales)

the variable vMaxYear should be defined in advance as follows:

vMaxYear=Max(If(Not IsNull(sales),Year))

(I have added the condition "If(Not IsNull(sales)" to be sure to select the maximum date available in your calendar where the sales data exists, not null).

Here is a useful article about set analysis: Sets Analysis: syntaxes, exemples

hope it helps!

regards,

Re: How to automatically have latest data in QlikView?

IAMDV — Sun, 04 Mar 2018 21:00:00 GMT

KB, you need to reload whenever data changes. QlikView or Qlik Sense both work in a disconnected mode. So, you either need to have a time-based trigger to reload your Qlik app or you need the event-based trigger to reload the app. Do you have QlikView server license?

Cheers,

Re: How to automatically have latest data in QlikView?

Qrishna — Sun, 04 Mar 2018 22:59:07 GMT

Hi for automatic update of your qlikview file, you have to write 'Incremental load' script (search for this process in the community for explanation) and set up a task on QMC to refresh/reload your application on 'daily/hourly/whatever the schedule' is.

Re: How to automatically have latest data in QlikView?

Anonymous — Mon, 05 Mar 2018 02:35:08 GMT

Hi Kh Fou,

Sorry for the general statement. Thanks for the tips.

I will try it out and also check the articles you sent.

Thanks again for the reply.

Regards

Re: How to automatically have latest data in QlikView?

Anonymous — Mon, 05 Mar 2018 02:36:41 GMT

Hi DV,

Thanks for the tips. Too bad I do not have QlikView server license.

I guess I will reload the data changes

Regards

Re: How to automatically have latest data in QlikView?

Anonymous — Mon, 05 Mar 2018 02:44:29 GMT

Hi Krishna,

Thanks for your reply and tips. I will search for this in the community.

Regards

Re: How to automatically have latest data in QlikView?

jyothish8807 — Tue, 06 Mar 2018 06:43:35 GMT

Hi KB,

In order to have the latest data in qlikview you have to reload the application when ever you want to see the latest data in the dashbord.

Now, since you do not have a server, you have to reload the dashboard manually. But to overcome this, you can create a batch script which will reload the application automatically.

You can schedule this batch script in the task scheduler.

Hope this help.

Br,

Re: How to automatically have latest data in QlikView?

Anonymous — Fri, 09 Mar 2018 02:12:35 GMT

Hi KC,

Thanks so much for your tips. I am reloading manually now. Will find out how to create a batch script.

Regards

Re: How to automatically have latest data in QlikView?

jyothish8807 — Fri, 09 Mar 2018 06:51:25 GMT

Hi KB,

You can create a batch like this: Open notepad --> enter the below code -->Save as .bat

"C:\Program Files\QlikView\qv.exe" /r "Your application path.qvw"

EXIT

Br,

Re: How to automatically have latest data in QlikView?

Anonymous — Fri, 09 Mar 2018 09:17:18 GMT

Hi KC,

Thanks for the fast response.

Will give it a shot.

Have a great weekend!

Regards