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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 ',');