Double squared brackets for the restricted field

Jakub_Miśkiewicz — Thu, 10 Feb 2022 14:01:07 GMT

Hi - while using the section access restrictions in Qliksense May 2021 user can see the restricted values in some cases.

Example: if the section access was made for a certain user on the field [TRANSACTION CODE] the 4 values are displayed what is correct. The [Payment Transaction Code Key] field is in the same table as [TRANSACTION CODE].

All values are distinct hence 4 corresponding values should be displayed only for the [Payment Transaction Code Key].

If this user will create e.g. filter pane and type by hand [[Payment Transaction Code Key]] - double '[[ ]]' - all values are displayed.

Usage of [Payment Transaction Code Key] in the expression present proper restricted values.

Print screen attached.

Is it a bug or a new feature?

Re: Double squared brackets for the restricted field

Jakub_Miśkiewicz — Thu, 10 Feb 2022 20:20:52 GMT

An update: the problem seems to be only for the key columns e.g. COL3 in the below example:

Section Access;
Load * INLINE [
ACCESS, USERID, COL2
ADMIN, BI\QLIKSENSE_USER, 11
];
Section Application;

[Test_Table]:
LOAD * INLINE
[
COL1,COL2,COL3
1,11,111
2,22,222
3,33,333
4,44,444
5,55,555
](delimiter is ',');

[Test_Table_2]:
LOAD * INLINE
[
COL4,COL5,COL3
10,110,111
20,220,222
30,330,333
40,440,444
50,550,555
](delimiter is ',');

topic Double squared brackets for the restricted field in App Development

Double squared brackets for the restricted field

Re: Double squared brackets for the restricted field