Discussion Board for collaboration on QlikView Scripting.
What is the best practice to update section access frequently?
I need to update user access information at least twice a day. I am using QV 8.5 and was told not to use
partial reload because of its unusual(?) behavior from other users.
I believe it is the best to upgrade to 9.0 and use incremental load but till then, what will be the best way
to deal with it other than reloading all data which will take an hour?
Have you figured it out?
I tried a partial reload in QV9.0, but it didn't work. See my code below.
Section Access;LOAD ACCESS, NTNAME, COMPANYCODERESIDENT AUTO;// Partial reload section accessREPLACE ONLYSection Access;LOAD ACCESS, NTNAME, COMPANYCODERESIDENT AUTO;
Why don't you load all the data in intermediate qvw, say datamodel.qvw, and then in your app.qvw you load the section access & binary load from datamodel.qvw?
Binary load should not take an hour to load, so every time you change section access records, just reload the app.qvw.
Would this help?
Yes, using a binary load is the only possibility for updating the section access quickly. Thanks!
Your can try replace load in section access and load in section application.
I dont understand the replace load function, if it is used for you security section, what happens to the other tables???