Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
KB
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,
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,
DV
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.
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
Hi DV,
Thanks for the tips. Too bad I do not have QlikView server license.
I guess I will reload the data changes
Regards
KB
Hi Krishna,
Thanks for your reply and tips. I will search for this in the community.
Regards
KB
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,
KC
Hi KC,
Thanks so much for your tips. I am reloading manually now. Will find out how to create a batch script.
Regards
KB
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,
KC