Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Attend QlikWorld 2020 and hear keynote speaker, Malcolm Gladwell. $300 savings extended to February 9th Learn More
Contributor III

Section Access query.

Hi all,

I have set a constrain in my section access and that works ok for the sheet I have applied it to (I have two sheets in my qvw). For example when the user logs in, they only see their assigned team stats on sheet 1.

The issue I am having is that this constrain is affecting the second sheet but none of the tables are related. So when that same member logs in they can only see partial information relating to that team on the second sheet.

Any suggestions how to fix this issue? 

Tags (2)
1 Reply
MVP & Luminary
MVP & Luminary

Re: Section Access query.

Apply section access to the data too using a section access table that links users to data values. See these blog posts:

A Primer on Section Access

Data Reduction – Yes, but How?

And these documents may be helpful too:

Introduction to Section Access

Section Access: Strict Exclusion

talk is cheap, supply exceeds demand