Hello All - I have a very simple qv file that is pulling a very small amount of data from Excel. The qv file has one sheet and one chart. I want to use this as a dashboard that will update automatically as the Excel data is changed. I would like to have the file automatically update, say every 2 minutes, to reflect any changes.
I have looked at other expamples posted here using variables, macros and triggers but cant seem to get it working. It may be that the samples posted here are more complicated than what I'm trying to achieve, but it's more likely that I just don't get it (my V basic skills are minimal) 🙂
Would love to hear from anyone that has a simple solution to this.
Hi Ajay - thanks but I have already figured out how to do it via a previous post. I ended up using a macro - the reason I couldn't get it working was due to some incorrect triggers I was using. I have used the batch file in previous applications to reload the file - in this particular application I wanted to keep the file open and refresh without closing (similar to a call centre dashboard).
Sorry Ajay - should have mentioned that the solution came from a different discussion - not an earlier post in this discussion. Please seee http://community.qlik.com/forums/t/17247.aspx
