topic Re: Separate section access data in QlikView

Separate section access data

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

I have bellow section access:

I have 3 different users

User1: can see the hospital names a1..a5

User2: can see the hospital names b1..b5

And admin that can see all the hospital names

I want to normalize my section access that no need to repeat user1 or user 2, in fact user 1 just use one row.

How can i make excel file?

I would appreciate if anyone could help me

Re: Separate section access data

marcus_sommer — Wed, 11 May 2016 10:55:45 GMT

Maybe you could group your hospitals in an extra field "hospital group" with the values of a (includes a1..a5) and b (includes b1..b5).

- Marcus

Re: Separate section access data

Gysbert_Wassenaar — Wed, 11 May 2016 10:59:25 GMT

Create tables in Section Application like

SECTION Application;

UserHospitalAccess:

LOAD * INLINE [

USERNAME, hospital name

user1, a1

user1, a2

...etc

user1, a5

user2, b1

user2, b2

...etc

];

UserSheetAccess:

LOAD * INLINE [

USERNAME, sheet1, sheet2, sheet3

user1, 1,1,1

user2, 1,1,1

user3, 1,1,1

];

Make sure that all the fields in the Section Access table are in UPPERCASE. So USERNAME instead of Username. USERNAME also has to be in uppercase in the other tables otherwise you can't use these tables to reduce the data in the document for the users.

Re: Separate section access data

stabben23 — Wed, 11 May 2016 13:35:50 GMT

Hi,

you can add the all togheter in one row With ex ';' separated, then use subfield in Your LOAD script.

ACCESS	Username	Userkey	Hospitalname
ADMIN	admin	*	*
USER	User1	a1;a2;a3;a4;a5	a1;a2;a3;a4;a5

LOAD

upper(subfield(Userkey,';')) as Userkey

Re: Separate section access data

Anonymous — Sat, 14 May 2016 04:00:14 GMT

Hi thanks for replying

can you give me an example of excel and coding section?

Re: Separate section access data

Anonymous — Sat, 14 May 2016 08:49:37 GMT

Hi thanks for replying