Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
I have been learning qlikview for few hours, I had imported the excel sheet into qlikview, based on that I had created a chart, but the values in the excel sheet is changed. But my chart in the qlikview is created based on the old excel sheet's value. Is it possible to display the chart based upon the recent updates from excel sheet into qlikview?
For example I have an excel sheet in the name of "customer.xlsx" which contains 10 customer's name initially, and importing it to the qlickview, after few weeks this 10 customer's name in the excel sheet becomes 50 customers, but the qlikview shows only 10 customers, how do I handle this ?
Reload your updated excel sheet in qlikview.
- You need to keep fix excel format
- As soon as you re-load your qlikview document automatically all users will update in qlikview
by using latest updated excel file. you need to keep a track on excel file format.
Hope this help you.
Vikas
You can schedule your reload whenever the data changes in excel using Normal Windows scheduler also..There are some 3rd party tools also available like 24X7..
Selva
Hello,
You have to reload the application again to get the updated records.
Thanks,
Angad
Hi Varun,
Whenever data is updated, Please refresh the Qlikview document as well automatically it will update. But if you are expecting with out touching the document/qlikview application, if you want to reload whenever data has updated in excel then there is process. for that you need to create a trigger for that.
Hi,
place this document in qlikview server and and go to document properties and configure qlikview document reload
Everyone
How to reload the excel document in qlikview? Please help me guys.
NOTE:
I am using qlikview Personal Edition.
Thank You
Varun Krishna. P
press Ctrl + R
@Abhishek Neti
Ok, Thanks I'll try it and let you know.
Thanks,
Varun Krishna. P
Reload your updated excel sheet in qlikview.