Facing some issue with after distribution the QVW

[NaveenTeam143]

I have Qlik application it contains 13 countries plants level data.

I have implemented section access which working fine for country level and plant level.

Now the issue is we are breaking the application in QMC using countryname field by reduce method now I will get 13 country applications I will get my access point.

But I have given access to one user for 3 countries in section access still he able to see all the 13 countries applications.

Please provide a better solution. 

[rubenmarin · Accepted solution]

Hi, have you checked the 'strict exclusion' option?

Remember to have a backup of the app to avoid unexpected lock of access to everyone (including yourself).

[Brett_Bleess · Accepted solution]

If Ruben's post was the issue, please be sure to close out your thread by circling back and using the Accept as Solution button on his post to give him credit for the assist and let other Members know that was the issue.  If you figured something else out, please consider posting that and then mark that post.  

I am going to add a few things that may be of some further help to others that find this post too.

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Section-Access/ba-p/1465766

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/Security.htm

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/QMC/Content/QV_QMC/QMC_Documents_SourceDoc...

I was a little confused though as you mentioned using Publisher to loop and reduce things, which normally would produce a separate application for just those countries and you would be best off linking the users to the data model such that you could then do a Loop and Distribute as well that would lock everything down without section access at that level, you may still need it for other dimensions it seems though, but you want to be careful mixing Loop and Reduce and Dynamic Data Reduction in Section Access as the two together can lead to unexpected consequences.

Regards,
Brett