Section Access

marcus_sommer · Sep 30, 2022 7:25:47 AM

How could I make sure that certain data are only for certain users available?

The answer is SECTION ACCESS. Section access is a connection between an authorization table (commonly placed in a hidden script and/or outsourced in an include-variable) and the application data (most to a dimension table).

Further you need to enable section access within the document properties in tab open and especially to enable the strict exclusion is important then without this is section access more a comfortable usability function to avoid confusing by the users which needs only a small data-area from the application but not more suitable for real confidential data.

Introduction to Section Access

A Primer on Section Access

Data Reduction – Yes, but How?

Section Access: Strict Exclusion

QlikView Section Access Examples

Data Reduction Using Multiple Fields

Section Access (Data Reduction) using Active Directory

In addition to these there are more complex restrictions possible but before you build one think on alternatives like Document chaining whereby those applications then have a specialized and simpler section access.

Basics for complex authorization

Authorization using a Hierarchy

Restrictions based on section access could be applied on sheets and objects.

Sheets Security with Section Access

Sheets Security with Section Access File

Chart Level Access by user

Sheet level access

Sometimes there is a need to mask or de-identify data for certain users, for this see: Mask or de-identify data for certain users using Section Access.

At least the most important remark: before thinking on section access makes one or more BACKUP's from your applications then there aren't any go backs by mistakes! One exception (which don't nullified the suggestion of having Backup's) could you find here: Bypassing QlikView Section Access – Infinity Insight Blog.

There is some content-overlapping within the above used links but I think the complement to each other is useful and of course you will find many more interesting postings here within the qlik community to these topic - the notes here are a good starting point to go further.

Have fun!

Marcus Sommer

marcus_sommer · ‎2017-12-08

Personally I would tend to solution 1 whereby I would try to build this table as far as possible automatically maybe by reading at first which countries/destinations and maybe users exists within the data and then looping/joining them all together.

I'm not sure that this would be mean lesser efforts than building the bridge-table from solution 2 but I don't like much the approach of linking-tables and therefore try to avoid them if possible.

- Marcus

bvmike2001 · ‎2017-12-08

Hi Marcus,

thanks for your advice!

Regards,

Mihai

prieper · ‎2018-09-26

Hi Marcus,

do you know a way to check from outside (probably reading xml-header or the like), whether a certain application has a security applied?

Peter

marcus_sommer · ‎2018-09-26

Hi Peter,

yes, it's possible by reading the xml - if there exists any users by SectionAccessNames. Here is an example to it: http://www.infinityinsight.com/blog/?p=324

- Marcus

jpk · ‎2021-09-07

Hi @marcus_sommer

Really great post, most appreciated.

Ebiexperts a Qlik Technology partner has launched an automated Section Access product to the market.

The product is called SAM: Section Access Manager for Qlik

Qlik Integrated & Authenticated
Self-service no-code
Automation options
Active Control SingleTouch
Admin
E-Learning

This is the MVP release and fully automated.

Regards

JP

jonas_rezende · ‎2022-11-23

Hi, @marcus_sommer .

Thanks for sharing!

inam · ‎2023-09-22

Hello ,

I am Created 1 dashboard & i want to create the section access.

In Raw DATA i have column 'Destination Country' so i change as UNIT

[Destination Country],
if(WildMatch([Destination Country],'*Thailand*'),'Thailand',
if(WildMatch([Destination Country], '*Indonesia*'),'Indonesia',
if(WildMatch([Destination Country], '*Singapore*'),'Singapore',
if(WildMatch([Destination Country], '*Vietnam*'),'Vietnam',
if(WildMatch([Destination Country],'*Malaysia*'),'Malaysia',
if(WildMatch([Destination Country], '*Cambodia*'),'Cambodia',
if(WildMatch([Destination Country], '*Laos*'),'Laos',
if(WildMatch([Destination Country],'*Myanmar*'),'Myanmar',
if(WildMatch([Destination Country],'*China*'),'China','Non-AT Countries'))))))))) as [UNIT],

I have Column UNIT in this there is multiple country please find below

i am created section access but its not working please find below ( here work only user id and password for example HAMD open the application user id and password working properly but In UNIT show all Country instead of Thailand)

and i am also created below but its not work

Please Help me how I solve this Section access i just want to show HAMD Thailand ,kHNIN Singapore & CHILVERICC Laos.

Section Access

Section Access

Application Development

QlikView