https://community.qlik.com/t5/App-Development/how-to-prevent-expanding-one-dimension-in-pivot-table/m-p/2128827#M91817 <P>I've found a possible solution.</P> <P>Within the formula I check the value of the dimension AND the "Dimensionality", which looks like that:</P> <P>if(DIMENSION1='Name of Dimension' and <STRONG>not</STRONG> Dimensionality()=2,<BR />sum(whatever)<BR /><BR />As a Result, I can click on the "+ symbol" which turns into a "- symbol" but nothing else happens.<BR />Maybey someone has a more elegant solution, but I'm happy with that.</P> <P>Cheers</P> Mon, 16 Oct 2023 13:53:39 GMT markuskoessler 2023-10-16T13:53:39Z https://community.qlik.com/t5/App-Development/how-to-prevent-expanding-one-dimension-in-pivot-table/m-p/2128769#M91814 <P>Hi everyone,</P> <P>I'm working on a pivot table with some dimensions and I would like to prevent the user to expand one of those dimensions. Any ideas how to solve that?</P> <P>Thank you!</P> Mon, 16 Oct 2023 13:23:40 GMT https://community.qlik.com/t5/App-Development/how-to-prevent-expanding-one-dimension-in-pivot-table/m-p/2128769#M91814 markuskoessler 2023-10-16T13:23:40Z https://community.qlik.com/t5/App-Development/how-to-prevent-expanding-one-dimension-in-pivot-table/m-p/2128827#M91817 <P>I've found a possible solution.</P> <P>Within the formula I check the value of the dimension AND the "Dimensionality", which looks like that:</P> <P>if(DIMENSION1='Name of Dimension' and <STRONG>not</STRONG> Dimensionality()=2,<BR />sum(whatever)<BR /><BR />As a Result, I can click on the "+ symbol" which turns into a "- symbol" but nothing else happens.<BR />Maybey someone has a more elegant solution, but I'm happy with that.</P> <P>Cheers</P> Mon, 16 Oct 2023 13:53:39 GMT https://community.qlik.com/t5/App-Development/how-to-prevent-expanding-one-dimension-in-pivot-table/m-p/2128827#M91817 markuskoessler 2023-10-16T13:53:39Z