In QlikSense, how can the amount of searchable data be restricted?

[trosclairson345]

Hi there,

A restricted or limited search option is necessary for QlikSense to function effectively.

There are the following amounts of data:

[Inline] [Loading

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

];

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

Here's what it looks like:

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

I would greatly appreciate your assistance in this matter. Thanks

[QFabian]

Hi @trosclairson345 , the background color of the displayed values from a field make the difference, because if you have selected B, numbers 2 and 3 should appears with a white background color. It is about the magic of the aasociative logic that makes qlik unique.

When you see gray background, it is telling you that values arent involved with the current selection.

But, in analysis, is very usefull to see what is happening (related to your selections) and what is not, so you can easily get  deeper insights

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Selections/use-selec...

https://help.qlik.com/en-US/sense/November2022/Subsystems/Hub/Content/Sense_Hub/Selections/use-selec...