topic Re: SECTION ACCES in QlikView

SECTION ACCES

souadouert — Wed, 25 Nov 2020 16:16:04 GMT

HI,
i have questions about using the dct section access and data reduction, i followed the next step.
I defined in my script the access table: user_id, password, privilege
then I enabled the data reduction feature in the document properties.
at this step, I did not understand how used the where to reduce the data,
load * from X where REGION = (the user)
and a second point if I will not use the password is that it poses a problem

THANK YOU

Re: SECTION ACCES

sunny_talwar — Tue, 30 Apr 2019 13:21:09 GMT

Already back to working?

I am not sure I understand your question, would you be able to elaborate a little?

Re: SECTION ACCES

souadouert — Wed, 08 May 2019 09:51:24 GMT

Hello suuny

yes I work hahaha
I solved my problem the idea is to reduce the data according to the connected user profile

Re: SECTION ACCES

Brett_Bleess — Wed, 19 Jun 2019 20:25:03 GMT

Just a potential help for you going forward if you get into more complex setups, here is a Design Blog post from Henric Cronstrom on Section Access, there are some associated links at the bottom of the post as well to other related topics, this should be a big help hopefully.

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

Oh, and one troubleshooting step I use is to comment the Section Access line of the script, but I leave the rest of the table load, this way it becomes part of the visible data model, so you can check things out that way to be sure things are connecting properly, and you can then also use List Boxes to be sure when you select a user, the other fields reduce down properly etc., and once you know you are good, then uncomment the Section Access line again and put it out there for final testing. As always, when doing Section Access, be sure to keep a backup of the file without Section Access somewhere in case you lock yourself out of the app! 🙂

Regards,
Brett