What is Section Access – For Qlik Beginners

                                                 ** Repetition is the crux of Education **
Section access is one such topic which can be discussed for hours together as it has a greater usage in QlikView/Qlik Sense.

First of all
What is the use of Section Access ?
Lets take a simple scenario.
A university is maintaining students data in a data base and created some analytics over that and shared that files to all the Department heads using QlikView Access point. Now the rule here is when a Department head opens that file he has to see analytics of his students not the other department students…..

Hope you got the requirement. To make it simple

University contains – 7000 students
——————————————–
IT Dept                   – 1000 students
ECE Dept               – 1500 students
MCA Dept             – 1000 students
MBA Dept             – 2000 students
Civil Dept              – 1500 students

Now if a Department head of IT Dept logs in to the file, how many students analytics he has to see ?
1000 – Correct!

This is section access, it means the original file is loaded with all students data but when a department head open the file he has to see his student data only.

This concept is also known as Data Reduction (or) Row Level Security as the security is on the data or on the rows.

Hope this makes sense on understanding What is Section Access in QlikView/Qlik Sense.

I will come up with some more concepts on Section access with examples to practice in my next posts.