Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
It is a repeated topic:
[],
Pedro
The following expression displays only IDs related to code B
=Aggr(if(Code='B',ID,Null()),ID)
It is a repeated topic:
[],
Pedro