Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear All,
It is necessary to restrict or limit the search option in Qliksense.
Here are the amounts of data:
[Inline] [Loading
Code,ID
A,1
B,2
B,3
D,4
E,5
];
I have set up a Table Chart in Qlik Sensitive so that only the data with the code B will display.
For the backend, where (Code='B',Code) is the same code as the BCode in the Qlik Dimension for the frontend
I have used the following expression.
The output is as follows:
When I search by ID, I see all records. 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
Would you like to restrict the data in a table to the value "B" in the worksheet? Create the Table in worksheet chart and add the code field as a dimension. Please use the following formula as a measure:
=Count({<Code={"B"}>}ID)