Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

deerhunter
Contributor

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 !

Tags (1)
1 Reply
pradosh_thakur
Valued Contributor III

Re: Section Access June release Challenge

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

Community Browser