topic Re: Pivot table horizontal scrolling disabled in QlikView

Pivot table horizontal scrolling disabled

Mon, 27 Aug 2012 04:05:46 GMT

Hello,

I'm using a Pivot table to display a detailed report for the users. I have around 20+ fields to be displayed. I have added all the fields as dimensions and then one field (Eg. Sum of notional) as the expression field. All works fine for me as expected. I'm able to group by the dimension fields which is really good.

The only issue I have is that as I expand to view the row data my Pivot table expands horizontally making my screen grow bigger. Instead I would like to keep the Pivot table width fixed but add a horizontal scrollbar automatically as the fields get expanded. This works for a table box but a table box cannot be used for grouping.

Im using QlikView 10 and there is no way I can add the dimensions as expressions which will display a horizontal scrollbar because it displays wrong information.

Cheers

Re: Pivot table horizontal scrolling disabled

whiteline — Mon, 27 Aug 2012 16:10:21 GMT

Uncheck "Chart Properties -> Layout -> Size to Data".

Re: Pivot table horizontal scrolling disabled

Mon, 27 Aug 2012 16:12:05 GMT

Another option (works best in Ajax view) is to just add the pivot table to a container. This will not allow it to grow. This however has some issues in desktop

Re: Pivot table horizontal scrolling disabled

Tue, 28 Aug 2012 02:37:56 GMT

Hi,

Unfortunately, this did not help.

Cheers

Re: Pivot table horizontal scrolling disabled

romain_bourdon — Tue, 29 Apr 2014 14:39:08 GMT

Hello,

I've got the same problem. Is there a solution now ?

Thanks.

Romain

Re: Pivot table horizontal scrolling disabled

juleshartley — Tue, 25 Nov 2014 09:58:29 GMT

Me too!

Re: Pivot table horizontal scrolling disabled

Thu, 14 May 2015 15:42:33 GMT

Hi, someone how know resolve this ? I have Qv 11.2 SR 10 😕

Thanks for help!