Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Does QlikSense allow you to restrict or limit search option data for tables?
Hello,
The search option in Qliksense needs to be restricted or limited.
The amount of data is:
[Inline] [Loading
Code,ID
A,1
B,2
B,3
D,4
E,5
];
Table Chart in Qlik Sensitive is configured as follows: I only need the data where the code is B to be displayed, so I created a chart.
If (Code='B',Code) is present in both the backend and frontend of Qlik, the BCode was also included in the Qlik Dimension.
Here is the expression I used.
As a result, we get the following:
I see all records when I search by ID. The only records that should be displayed are those with code B of 2,3.
I would greatly appreciate any assistance you can provide in this matter. Thanks
Hi @alsahalex,
It is a repeated topic:
[],
Pedro
Since you are searching by IDs, use this
If (Code='B', ID)
Or
Aggr(Only({<Code={'B'} >}ID),ID)
Hi @alsahalex,
It is a repeated topic:
[],
Pedro