Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have several input fields that write to a local database and are then pulled back into the dashboard. I would like to be able to reload just this table (either automatically or with a button). It is very small and loads rapidly while my main application takes fairly long to run even using incremental loads.
I have tried the partial reload manually but get an error message when it hits the incremental load parts (where we Store the data back to the qvd). What would be the easiest way to have only this table reload. I would like it to either reload automatically whenever a new row is stored in the table or else have a button that the user could use to refresh the data.
Any help would be appreciated!
The partial and incremental reloads together might create issues for you because you might have maps/joins in the incremental logic. This can be the cause of error during store. Few points:
>> You can run a macro trigger on a button for data load (search in the forum, you will get many discussions on this )
>> Run a separate QV application in the server to refresh the QVD and refresh the dashboard from this.
>> Dynamic Data Update is possible in QV 9.x, with a separate licensing for the utility.
--Arun
Where can I find out more about the Dynamic Data Update. I think this may be the answer I am looking for as the reloads are going to be fairly lengthy for what I am trying to do and partial reload will probably not work since I do have a lot of Maps and Joins.
The PDF document 'QlikView Automation Reference' (available under downloads) has s section on this with an example.
--Arun
I faced with the same problem recently - http://community.qlik.com/forums/p/21751/83426.aspx#83426 may be it'll be useful for you.