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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
ali_hijazi
Partner - Master II
Partner - Master II

hide / disable filtering in a pivot table

Hello
got a pivot table like below:

ali_hijazi_0-1764943160454.png

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

I can walk on water when it freezes
Labels (2)
2 Replies
rubenmarin

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) 

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

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

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.