Hi,
we have the following issue: we have a field USERNAME which is used in the SectionAccess table to restrict user access to the data of a specific user.
In general, it works fine. However, if we use the field USERNAME in a dimension together with the following Set Analysis expression: {$<VALUE={1}>} USERNAME , the resulting dimension values contain ALL usernames including those which should be hidden by Section Access.
The version we use is Qlik Sense Enterprise on Windows August 2023 Patch 6. We could not reproduce the behavior using Qlik Sense Enterprise on Windows November 2021 Patch 4.
The following loadscript provides a minimal working example, results are attached:
Data:
Load * Inline [
USERNAME,VALUE
Abc,1
Abc,2
Def,3
Ghi,4
];
Data2:
Load
USERNAME,
1 As VALUE2
Resident Data;
AccessTable:
Load Distinct * Inline [
ACCESS,USERID,USERNAME
ADMIN,INTERNAL\SA_SCHEDULER,*
USER,*,Abc
];
Section Access;
SectionAccess:
Load * Resident AccessTable;
Section Application;
Drop Table AccessTable;
Is this a known issue and when will there be a fix?
