Can the search option for tables in Qliksense be restricted or limited?

[Alexandersalt87]

Hi there,

QlikSense's search option needs to be restricted or limited.

The amount of data is as follows:

[Inline] [Loading

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

];

I created a table chart in Qlik Sensitive that displays only data with the code B.
If the code is 'B', the backend and frontend are the same.
Below is the expression I used.

Here is the output:

I see all records when I search by ID. Display only records with code B of 2,3.

It would be greatly appreciated if you could assist me in this matter. Thank you.

[BrunPierre]

The following expression displays only IDs related to code B

=Aggr(if(Code='B',ID,Null()),ID)

[pedrobergo · Accepted solution]

Hi @Alexandersalt87 

It is a repeated topic:

• https://community.qlik.com/t5/New-to-Qlik-Sense/Does-QlikSense-allow-you-to-restrict-or-limit-search...
• https://community.qlik.com/t5/New-to-Qlik-Sense/What-are-the-options-for-limiting-the-amount-of-data...
• https://community.qlik.com/t5/New-to-Qlik-Sense/Can-the-search-option-for-tables-in-Qliksense-be-res...

[],

Pedro