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

[@bigbrainwithabb1606]

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

[@renanlndr]

Wonderful video! Thanks for sharing this knowledge

[@anjaliahlawat6491]

Great share 👌👌

[@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 🧐

[@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.

[@deepankan03]

Amazing

[@harithadogiparthi9450]

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

[@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