How to restrict/limit search option data in Qliksense for Table chart

[qvqs14]

Hi Team,

I want to restrict / limit the data in search option in qliksense.

Please find the below inline description along with attached document.

Data:

Load * Inline [

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

];

I have created a Table Chart in Qlik sense, I need only Where Code = B Data need to Display, I created a
Backend or front end Exp where Backend: if(Code=’B’,Code) as BCode same into the Qlik Dimension
expression I have used.

Output is this:

When I search in the ID field, I am seeing all the records, it should show only where the code B is 2,3

Please help me on the same. Thanks in advance.

Note : How we can convert dimension into Measure in qliksense.

Regards,

QVQS14

[BrunPierre]

Replace the ID field with the expression below

=IF(BCode='B',ID)

[vinieme12]

use  calculated dimensions

ID = Aggr(Only({<Code={'B'}>}ID),ID)

Code = Aggr(Only({<Code={'B'}>}Code),Code)