Qlik : 005_Section Access : Row level data reduction on multi field using Link Table

In this video, we will learn how to implement row level data reduction on multiple field using link table in Qlik Sense.
We will see how to create link table with dynamic records to handle access scenario with ALL fields of a particular field.
#QlikSense #QlikView #SectionAccess #DataReduction #Qlik #QlikSolution

[@bigbrainwithabb1606]

Amazing to see such a clear, structured and well explained video. 👍Its so helpful!!

[@thanmayap]

Hi Manish.. Thank you so much for a very detailed , clear , simple and in depth explanation .

[@narband2778]

Thanks for in-depth section access analysis 🧐

[@renanlndr]

Wonderful video! Thanks for sharing this knowledge

[@anjaliahlawat6491]

Great share 👌👌

[@deepankan03]

Amazing

[@VishalGupta-nq9kb]

Amazing explanation
Simple and easy to understand.
Please add a video to handle section access directly from sql database and not manually in inline load.
This would be really helpful

[@manishkumarkachhia1683]

There should not be any major difference in loading table from SQL. It could be something like below.
LIB CONNECT TO 'SQL_Data';
SQL SELECT
ACCESS
,USERID
,COUNTRY
,PRODUCT
FROM Schema.dbo.SectionAccess;

[@VishalGupta-nq9kb]

@@manishkumarkachhia1683 thank you for replying.
Generally who maintains this section access table in sql?
In my current project we are not getting any user details tables customised for qlik.

[@manishkumarkachhia1683]

@@VishalGupta-nq9kb It depends on project by project and company by company. There is no rule on who will handle the section access data. It depends on roles and responsibility.

[@faibichandrei3189]

Tanks for so clear and ultimate explanation, but what about a case when fields are in different tables? For example Countries and Departments, and we need to arrange access according combination scheme you discribe.

[@manishkumarkachhia1683]

You can bring them to one table and apply section access. I will soon create video on it.

[@cherianjohn8559]

Hi Manish, Do you take training session on QS.

[@manishkumarkachhia1683]

Sometimes

[@harithadogiparthi9450]

Hi Manish. Why Access table is not visible in data model?