topic Pivot Display - Expanding - Allow Pivot in QlikView

Pivot Display - Expanding - Allow Pivot

Tue, 16 Mar 2010 09:17:17 GMT

Hi Guys,

I have a requirement that a P&L pivot is set to disallow pivoting, but the pivot level remain inconsistent. Please see the image below.

You will see that the bottom three lines have not been pivoted. It is necessary that these remain unpivoted and the user cannot interact with them in any way.

Is this possible?

I've tried to uncheck 'Allow Pivoting' but to no avail.

Thanks.

Pivot Display - Expanding - Allow Pivot

Tue, 16 Mar 2010 09:32:09 GMT

Hi Matt,

If you want to expand all the columns / selected columns, right click the particular column and Select the "Expand all".

If you want to expand all the column on whole, choose the properties and in the presentation tab you will find the option "Always full expand". This will expand all the columns.

If i'm correct ok, if not could you please tell me clearly.

Pivot Display - Expanding - Allow Pivot

Tue, 16 Mar 2010 09:43:08 GMT

sorry, i want inconsistent expansion levels. I don't want to full expand the whole pivot table.

Pivot Display - Expanding - Allow Pivot

Tue, 16 Mar 2010 09:51:46 GMT

There seems to be no way to set non-expansion for single fields in a column (at least not that I can find easily), but there is a small trick that might work for you.

If the display of the table never changes, you could create a text box object with full opacity and put that on top of the table. That way, nobody can make a selection in the table.

Pivot Display - Expanding - Allow Pivot

Wed, 17 Mar 2010 12:26:37 GMT

If you make it as Detached under the general tab it seems to do the trick. But test it thoroughly as that might bring about unwanted behavior