Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
got a pivot table like below:
is there a way to disable filtering on scenario from the pivot table itself?
kindly advise
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)
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