Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Frequently Updating section access

Hi.

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?

Thanks,

Ryan

5 Replies
Not applicable

Frequently Updating section access

Hi Ryan,

Have you figured it out?

I tried a partial reload in QV9.0, but it didn't work. See my code below.

Regards,

James.

Section Access;
LOAD
ACCESS,
NTNAME,
COMPANYCODE
RESIDENT AUTO;
// Partial reload section access
REPLACE ONLY
Section Access;
LOAD
ACCESS,
NTNAME,
COMPANYCODE
RESIDENT AUTO;

disqr_rm
Valued Contributor III

Frequently Updating section access

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?

Not applicable

Frequently Updating section access

Yes, using a binary load is the only possibility for updating the section access quickly. Thanks!

Not applicable

Frequently Updating section access

Your can try replace load in section access and load in section application.

Not applicable

Frequently Updating section access

I dont understand the replace load function, if it is used for you security section, what happens to the other tables???

Community Browser