What is the option for restricting or limiting the amount of data available for search in QlikSense?

[churchillsonm95]

Hi there,

In order to use QlikSense's search option effectively, there must be a restriction or limitation.

The data amounts are as follows:

[Inline] [Loading

Code,ID
A,1
B,2
B,3
D,4
E,5

];

I created a table chart in Qlik Sensitive to display only data where the code is B.
If the code is 'B', code is the same in the backend and the front end.
I have used the expression below.

The output is as follows:

When I search by ID, I see all records. Only records with code B of 2,3 should be displayed.

If you could assist me in this matter, I would greatly appreciate it. Thanks

[pedrobergo]

Hi @churchillsonm95 

You didn´t share expression and output, but I believe that you trying to restrict the dimension values on a table but the formula is on measure.

To restrict search info on dimesion, you need to insert formula on it like: 

if(Code='B',Code)

If you want to restrict all info, except B code to user, please take look on Section Access - https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Security/m... .

[],

Pedro