topic Re: partial reload section access in QlikView

partial reload section access

nkosinde13 — Wed, 25 Nov 2020 16:16:04 GMT

Good day community

I have the script below which applies section access on my dashboard. So everytime I make changes to the spreadsheet it's pointing to I have to do a full reload to apply the changes which takes quite long.

Can you please assist with "partial reload" script as I tried with the one below and it's not working: Or do I need two scripts, one for partial reload and one for full? How does it work?

section access;
if IsPartialReload() then

Access:
Replace LOAD Upper(ACCESS) as ACCESS,
Upper(USERID) as USERID,
Upper(PASSWORD) as PASSWORD,
Upper(NTNAME) as NTNAME,
Upper([Business Unit]) as [BUSINESSUNIT]
FROM
[D:\QlikView\FTP\Matlotlo\Users Access List_MatlotloWIP.xlsx]
(ooxml, embedded labels, table is [Section Access]);

section Application;

Grouping:
Replace LOAD NTNAME As [NT NAME],
[OS GROUPING],
HR,
[Title Manco],
Exceptions

FROM
[D:\QlikView\FTP\Matlotlo\Users Access List_MatlotloWIP.xlsx]
(ooxml, embedded labels, table is [Section Access Detail]);

Thanks and regards

Re: partial reload section access

Stoyan_Terziev — Mon, 18 Nov 2019 14:55:19 GMT

Try this:

Copy your QVW without the access script.

Create new QVW which uses Binary Load to the first QVW and applies the Section Access (That' would be the QVW you want to point your users to).

Binary load usually goes much faster than what your script would normally take to execute since it only loads the data previously transformed.

Kind regards,

S.T.

Re: partial reload section access

nkosinde13 — Tue, 19 Nov 2019 09:26:24 GMT

Thank you @ST . But now the qvw that I create the binary script on, does it need to have the same data load as the original document? or is it just a blank document with no data set, just binary load and section access script?

Because I made a copy of the original document and added binary load and section access script and deleted the section access script on the original one. I'm now running the one with binary load and reload time seems to be the same as before?

Thanks

Matlotlo

Re: partial reload section access

Brett_Bleess — Wed, 20 Nov 2019 18:10:33 GMT

Matlotlo, I think what Stoyan was suggesting was to keep the original app as the data model etc., and the new app would have the Section Access script as well as the layout from the original app too. The binary of the original into the new app would put the data model plus the section access into the new app for you. That all being said, the only reason of which I can think things would be slow would most likely be something in the data model not being optimized and tied into the reduction field you are using etc. Hopefully this helps, I am sure Stoyan will pop back too, I just wanted to try to help here...

Regards,
Brett

Re: partial reload section access

nkosinde13 — Thu, 21 Nov 2019 07:35:16 GMT

Thank you @Brett_Bleess . Yes you are right, the model itself is not optimized, it's huge with a couple of sync keys. Optimizing it will be a mission but has to be done in due course. I did run the binary load but it still took the same amount of time so since I'm just testing access I'm doing a partial reload. Thank you all for the assistance @Stoyan_Terziev .

Regards

Matlotlo