Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master
Partner - Master

Section Access Limitation?

Hello

we've got a QVF to which we added section access
some users got ADMIN access and others got USER access with data reduction
we have no problems with ADMIN users and they see all data
some users and mainly those with USER access are not seeing all data they are supposed to see
let's say we have user U1, this user has over 1 million rows (distinct combinations) that link to schema
if we put all these combinations in the section access table, this user will not see all the possible linked data
but if we disable the "section access" and select the userid from UI there is no problem;

so I was wondering if there is a limitation in section access for the number of rows per user
kindly advise

I can walk on water when it freezes
1 Solution

Accepted Solutions
ali_hijazi
Partner - Master
Partner - Master
Author

it turned out there is a limitation of rows per user in the section access table
as per this article:
https://support.qlik.com/articles/000048245

 

the limitation is set to 1,000,000 rows
and it turned out that we exceeded this limit in the section access table (per user)

I can walk on water when it freezes

View solution in original post

3 Replies
eliran
Creator III
Creator III

There is no limitation for data reduction to my knowledge and experience.

Usually this happends when you don't really cover all of the situations.

What I usually do when there is a problem in the section access, is remove the 'section access / section application' part of the script, and just load the security table to the ERD schema.

Once there, I can understand fully what is happening with the data interaction.

 

I hope it helps,

Eliran.

ali_hijazi
Partner - Master
Partner - Master
Author

this is what I'm doing
when I remove the section access / section application I can check for that particular user what related data he can see and it is working fine
but once I enable section access that user won't see all related data
weird

 

I can walk on water when it freezes
ali_hijazi
Partner - Master
Partner - Master
Author

it turned out there is a limitation of rows per user in the section access table
as per this article:
https://support.qlik.com/articles/000048245

 

the limitation is set to 1,000,000 rows
and it turned out that we exceeded this limit in the section access table (per user)

I can walk on water when it freezes