Discussion board where members can learn more about Qlik Sense App Development and Usage.
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
Upper(ACCESS) AS ACCESS,
Upper(USERID) AS USERID,
Upper(DEPTID) AS DEPTID,
Upper(PROCCD) AS PROCCD,
Upper(OMIT) AS OMIT
(ooxml, embedded labels, table is Sheet1);
The excel reads:
Both (DEPTID & PROCCD) are fields in the model !
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