Skip to main content
Announcements
Customer Spotlight: Discover what’s possible with embedded analytics Oct. 16 at 10:00 AM ET: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
lblumenfeld
Partner Ambassador
Partner Ambassador

Can Section Access be used with partial reload?

I have a dashboard that is updated once per day (because that's the frequency of the data changes.) It uses data reduction based upon user authorizations. User authorizations may change during the day and we now have a requirement to have those changes applied to the dashboard. This may be as frequently as every 5 - 10 minutes.

For performance reasons, I don't want to refresh the entire dashboard that frequently. I tried using a partial reload to update only the section access and data reduction, but it's not working.

Here is the problem...

Prior to the SECTION ACCESS section, I am building a table with my authorized users. I've changed it to

MyTable:

Replace LOAD

     xxx,

     xxx,

     USERID,

     xxx

FROM

     the table source

Then in the SECTION ACCESS, I have

Replace LOAD

     xxx,

     USERID,

     xxxx

Resident MyTable

When a full reload is done, everything works perfectly. When a Partial Reload is done, I get an error on the second load statement that

"USERID could not be found in MyTable".

Question: What is causing this?

Things I've tried....

1. I put an exit after the first load statement and verified that USERID is definitely in MyTable.

2. I changed the second load to note be a Replace. I still go an error.

Question: Is it possible to rerun only the data reduction and section access? How can I do this?

Thanks.

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Hi,

Have you tried with IsPartialReload() ?  Like

if IsPartialReload() then

MyTable:
Replace LOAD
xxx,
xxx,
USERID,
xxx
FROM source;

SECTION Access;

New:
Replace LOAD
xxx,
USERID,
xxxx
Resident MyTable;

Section Application;     

exit script;
end if;



check this thread as well  Partial Reload

View solution in original post

3 Replies
settu_periasamy
Master III
Master III

Hi,

Have you tried with IsPartialReload() ?  Like

if IsPartialReload() then

MyTable:
Replace LOAD
xxx,
xxx,
USERID,
xxx
FROM source;

SECTION Access;

New:
Replace LOAD
xxx,
USERID,
xxxx
Resident MyTable;

Section Application;     

exit script;
end if;



check this thread as well  Partial Reload

fabdulazeez
Partner - Creator III
Partner - Creator III

Will it be possible to drop the MyTable in partial load?

SameulChukwezi
Contributor II
Contributor II

Partial reloads in Qlik may not properly update Section Access due to timing issues or synchronization problems with the USERID field. To resolve this, ensure that the USERID is fully available before applying the Replace Load in Section Access. Using a temporary table or performing a full reload can help maintain proper synchronization. Alternatively, consider using external scripts or scheduling full reloads to keep data and access controls up-to-date efficiently.