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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Jakub_Miśkiewicz
Contributor
Contributor

Double squared brackets for the restricted field

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?

1 Reply
Jakub_Miśkiewicz
Contributor
Contributor
Author

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 ',');