Do you have the capability of restricting or limiting search option data for tables in QlikSense?

[philipswilliam23]

Dear All,

It is necessary to restrict or limit the search option in Qliksense.

Here are the amounts of data:

[Inline] [Loading

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

];

I have set up a Table Chart in Qlik Sensitive so that only the data with the code B will display.
For the backend, where (Code='B',Code) is the same code as the BCode in the Qlik Dimension for the frontend
I have used the following expression.

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

[WildmoserGeorg]

Would you like to restrict the data in a table to the value "B" in the worksheet? Create the Table in worksheet chart and add the code field as a dimension. Please use the following formula as a measure:

=Count({<Code={"B"}>}ID)