topic hide / disable filtering in a pivot table in App Development

hide / disable filtering in a pivot table

ali_hijazi — Fri, 05 Dec 2025 13:59:50 GMT

Hello
got a pivot table like below:

is there a way to disable filtering on scenario from the pivot table itself?
kindly advise

Re: hide / disable filtering in a pivot table

rubenmarin — Fri, 05 Dec 2025 18:48:32 GMT

Hi, not the way I would like it, but the only way I found is to use a layout object, add the table to use 100% of widht and height, set 0% of x and y axes,so the table occupies all the layout object, and set above the table a transparent text object (set in background color), with expression like ='', so it's totally transparent to the user, and they can't click on the vertical dimensions (and depending of the x's % maybe neither on the horizontal dimensions)

Re: hide / disable filtering in a pivot table

Lech_Miszkiewicz — Sat, 06 Dec 2025 01:09:59 GMT

Hi @ali_hijazi

Not sure what your goal is. Yes - you can hide the bread-crumb objects in Pivot Table using CSS watch this here: https://www.youtube.com/watch?v=9lhL3Nrel5Q (via sheet styling or MultiKPI object - this object is superseded by sheet styling - depending on your current setup and version of Qlik Sense you are using), or by moving it outside of the layout container boundries or by covering it like @rubenmarin suggested but that itself will not stop users from being able to click values directly in the pivot table and filter from there.

You may as well use new Pivot Table object which looks little bit better but you will still be faced with the same issues.

cheers

Since there is no Read Only mode (which we have in QlikView and which was very useful for such scenario) I dont really see any way of preventing users from being able to filter