Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
deerhunter
Creator
Creator

Section Access June release Challenge

Can anyone see why this is not working? (Thanks in advance)

We want the app to react as follows:

USR1 = Can see all

USR2 = Can see only department = 2234, PROCCD = ABC and OMIT DEPTID = 1000

USR3 = Can see only department = 3200, PROCCD = EFG and OMIT DEPTID = 2000


//Script code:

Section Access;

LOAD

Upper(ACCESS) AS ACCESS,

Upper(USERID) AS USERID,

Upper(DEPTID) AS DEPTID,

Upper(PROCCD) AS PROCCD,

Upper(OMIT) AS OMIT

FROM [$(vSectionData)Security.xlsx]

(ooxml, embedded labels, table is Sheet1);

Section Application;

The excel reads:

ACCESS

USERID

DEPTID

PROCCD

OMIT

ADMIN

USR\USR1

*

*

USER

USR\USR2

2234

ABC

1000

USER

USR\USR3

3200

EFG

2000

Both (DEPTID & PROCCD) are fields in the model !

1 Reply
pradosh_thakur
Master II
Master II

i know it has been long and you might have found an solution also still.

Things to check

1: DEPTID AND PROCCD are caps in the model.

2: * means all listed value not all value in the model.

3: Your use of OMIT is wrong. It omits a filed for a specific user, not the field value

Learning never stops.