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