Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello there,
In order for QlikSense's search option to function effectively, it must be restricted or limited.
There are the following amounts of data:
[Inline] [Loading
Code,ID
A,1
B,2
B,3
D,4
E,5
];
Qlik Sensitive displays only data where B is the code in a table chart.
If the code is 'B', both the backend and frontend are the same.
Here is the expression I used.
Here is the output:
I see all records when I search by ID. 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
Hi, if you add a filter object and you do a search in that object, the values with the background in white are the values related to other selections, values not related will have a grey background.
As an alternative you can add a calculated dimension to the filter object, using "Aggr(ID,ID)" will only show values related to other selections.