Qliksense Search Options: How do I restrict or limit data for search options?

[markwelder]

Hello,

As a user of Qliksense, I would like to restrict or limit the data that is displayed when searching.

Data amount:

Load * Inline [

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

];

In Qlik Sense, I have created a Table Chart, where I need only the data from where Code = B to display, and I created a
If Code='B',Code) is the same as BCode into the Qlik Dimensions Backend or front end?
This is the expression I used.

The output is as follows:

When I search by ID, I see all the 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

[QFabian]

Hi @markwelder , one option is to create another table with data filtered, then use the new field to use in chart and make searches.

Data amount:

Load * Inline [

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

];

DataB:

Load 

ID,

Code    as CodeB

Resident [Data amount]

Where

   Code = 'B';