Section Access with big data

Anonymous — Mon, 26 Jan 2026 18:19:17 GMT

Hello QlikView Community,

who has experience with Section Access together with big data?

we use QlikView 11.2 SR3. The App is 1,4 GB and has 60 millions recordsets.

The Publisher makes daily reload and afterwards preload.

The Section Access table will be load from SQL Server.

Ca. 200 users have some different rights. Every user can see his data only. It works fine.

Our Problem: first time load performance. After preload on server every user has to wait ca. 40 sec for load of application. If we disable Section Access is the load time 1 sec only. The caching doesn't work first time because most users have different access rights.

What is the cause of this delay? What can we do?

Please not suggest the solutions "reduce the data" or "split the app". It is not possible.

Re: Section Access with big data

Anonymous — Wed, 30 Oct 2013 15:50:28 GMT

I'd use "loop and reduce" by User, so each user has access only to his own copy, and no need for section access.

If it's not possible, they'll have to live with 40 sec, I guess...

topic Section Access with big data in QlikView

Section Access with big data

Re: Section Access with big data