topic Re: Section access help in QlikView

Section access help

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

Hello Team,

I have applied Qlik view section access as below. the password is 123

The data on each tab is not excluded as per the section access with users given below.

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, upper(GU) as GU, upper(OG) as OG

ADMIN, ADMIN, ADMIN

USER, USER1, U1, ICEG,RES

USER, USER2, U2, UNITED STATES,OTHER

USER, USER3, U3, ASEAN,PRD

USER, USER3, U3, ANZ,CMT

];

Section Application;

Please can you help me to understand why it is not working?

Regards,

Savithri

Re: Section access help

Anil_Babu_Samineni — Sat, 27 Apr 2019 14:47:26 GMT

Try this way

Section Access;

LOAD ACCESS, USERID, PASSWORD, upper(GU) as GU, upper(OG) as OG INLINE [

ACCESS, USERID, PASSWORD, GU, OG

ADMIN, ADMIN, ADMIN,,

USER, USER1, U1, ICEG,RES

USER, USER2, U2, UNITED STATES,OTHER

USER, USER3, U3, ASEAN,PRD

USER, USER3, U3, ANZ,CMT

];

Section Application;

Re: Section access help

savithri_n_s — Sat, 27 Apr 2019 17:29:31 GMT

No. its not working.Can you please help?

Re: Section access help

Brett_Bleess — Wed, 19 Jun 2019 19:36:54 GMT

Here is a Design Blog link that may be of some help to you in sorting things out on your own, there are some further links to other posts in this one as well at the bottom. Oh, if you are expecting data reduction to work, be sure in the Settings\Document Properties\Opening tab settings you have the Initial Data Reduction checked as well as the Strict Exclusion, the latter is necessary to ensure everything works properly or locks someone out if there is any doubt on things. Be sure you keep a copy of the app without Section Access enabled just in case you lock yourself out! 🙂

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

Regards,
Brett

Re: Section access help

Brett_Bleess — Wed, 19 Jun 2019 19:39:11 GMT

Oh, I meant to add one other troubleshooting step I use sometimes too, if you comment out just the Section Access line in the script and let the table load without that statement, it will become part of the visible table structure, so you can then use list boxes etc. to make selections and see if things are actually reducing they way you expect or not, most of the time this will show you something you cannot see otherwise that will give you a clue as to why it is not working properly. Sorry I forgot to mention it in the other post, hopefully this will help too.

Cheers,
Brett