topic Re: Section Access in QlikView

Section Access

paulwalker — Fri, 15 Nov 2024 23:28:11 GMT

Hi Community,

Facing issue with Authentication.

I have two level access Country and Survey. each country has multiple surveys.

Example: Canada has multiple surveys (like A, B, C), One user needs full access all the surveys and one user needs only A survey access. (one particular Survey working fine, if I make for all survey(*) access not working for them)

Below are the list of users, which I have highlighted in red not working for them. showing access denied.

did I anything wrong?

ACCESS	NTNAME	COUNTRY	SURVEY
ADMIN	Admin User	*	*
USER	username1	Canada	*
USER	username2	Argentina	A
USER	username2	Argentina	B
USER	username3	Australia	Q
USER	username4	Australia	*

Sample Data:

COUNTRY	SURVEY	Sales
Canada	Book	300
Canada	Pencil	150
Canada	Ink	200
Argentina	A	200
Argentina	B	300
Argentina	C	200
Argentina	D	590
Australia	Q	500
Australia	Z	1300

Thanks in advance!

Re: Section Access

pradosh_thakur — Fri, 11 Dec 2020 05:48:18 GMT

you need to create a table which will contain all the combination of country & survey. use that table as mapping table. then use section access on that

1: Create a master table to contain all the combination

2: Make sure all are uppercase

3: add dummy records as * mean all the listed value

-Pradosh

Re: Section Access

paulwalker — Fri, 11 Dec 2020 06:15:31 GMT

Hi Paramod,

can you please explain how to make all possible combinations?