In Qliksense, is it possible to restrict data for search options?

[jameswilliam234]

Hello,

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

It contains the following data:

[Inline] [Loading

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

];

Here is how my Table Chart in Qlik Sensitive is configured: I am only showing data where the code is B, so I created a chart.
Where the Backend: if(Code='B',Code) is the same as the Qlik Dimension Backend: if(Code='B',Code) as BCode
expression I have used.

Output is this:

I see all records when I search by ID. Only records with code B of 2,3 should be displayed.

It would be greatly appreciated if you could help me with this issue. Thanks

[SerhanKaraer]

Hello James,

If you change data model, you can add a new column for searching.

LOAD *, if(Code = 'B', ID) as IDsForCodeB;

[Inline] [Loading

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

];

I hope it solves.