In QlikSense, how can the amount of data searched be limited?

[sebastianserfas]

Hello there,

In order for QlikSense's search option to function effectively, it must be restricted or limited.

There are the following amounts of data:

[Inline] [Loading

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

];

Qlik Sensitive displays only data where B is the code in a table chart.
If the code is 'B', both the backend and frontend are the same.
Here is the expression I used.

Here is the output:

I see all records when I search by ID. 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

[rubenmarin]

Hi, if you add a filter object and you do a search in that object, the values with the background in white are the values related to other selections, values not related will have a grey background.

As an alternative you can add a calculated dimension to the filter object, using "Aggr(ID,ID)" will only show values related to other selections.