Qlikview: Implementing Section Access on Multiple Fields

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

Hi, QlikView community,

I’m currently working on a QlikView app where I need to implement section access based on two fields: REGION and STORE. However, I have a unique situation and I’m seeking advice on how to solve it:

Data Model:

• I have two tables in my data model: Fact with fields like (saleid, customer_name, region, etc) and Annotations with fields like (region, store, category, etc). The annotations table is mainly used to map annotations to the fact table but is not joined to it. It is a stand-alone table

• I use an excel file with a table Authorization where I have fields like (ACCESS, NTNAME, SAUSER)
Finally after the section access, I have an inline table that maps SAUSER to region where my section access is currently applied to.

Section Access Requirements:

By default, all users in a region should have access to all stores in that region, but there is now a new store in one of the regions, and only specific users in that region should have access to it.

Challenges:

I need advice on how to set up section access to handle this exception. How can I configure the section access table to grant access to all stores in the region except for the newly opened one, while allowing specific users to access the new store?

Any guidance or examples on how to approach this would be greatly appreciated!

Re: Qlikview: Implementing Section Access on Multiple Fields

hic — Thu, 03 Oct 2024 19:13:16 GMT

It sounds as if you would need generic keys. Take a look at

https://community.qlik.com/t5/Design/Basics-for-complex-authorization/ba-p/1465872

Generic keys and other advanced scripting methods are described in my book "Qlik according to HIC".

Re: Qlikview: Implementing Section Access on Multiple Fields

Vegar — Fri, 04 Oct 2024 04:56:42 GMT

As HIC is saying or you apply logic on and transform your inline table into a table that maps your SAUSER to STORE and not to REGION.

topic Qlikview: Implementing Section Access on Multiple Fields in QlikView

Qlikview: Implementing Section Access on Multiple Fields

Re: Qlikview: Implementing Section Access on Multiple Fields

Re: Qlikview: Implementing Section Access on Multiple Fields