Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
oscarnancy234
Contributor
Contributor

In Qliksense, is it possible to restrict or limit the data available for the search option for tables?

Hello,

There needs to be a restriction or limitation on QlikSense's search option.

There are the following amounts of data:

[Inline] [Loading

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

];

I created a table chart in Qlik Sensitive to display only data where the code is B.
If the code is 'B', code is the same in the backend and the front end.
I have used the expression below.

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

Labels (1)
1 Reply
deepanshuSh
Creator III
Creator III

Then you need to use section access on the backend and restrict the data on the row wise/column wise manner. 

Trial and error is the key to get unexpected results.