topic Pivot Table Behaviour in QlikView

Pivot Table Behaviour

richard_chilvers — Thu, 07 Feb 2013 12:08:05 GMT

I have a fairly straight-forward pivot table (simple calculated dimensions).

If I scroll down and expand a column of the pivot, I skip back to the top of the table, rather than stay in the same scroll position.

I have check the Preserve Scroll Postion box on the Layout tab of the Chart Object.

What am I doing wrong ?

Richard

Re: Pivot Table Behaviour

Jason_Michaelides — Thu, 07 Feb 2013 12:16:10 GMT

Have you checked the Settings > User Preferences > Objects tab - at the bottom?

If that is also selected, then substitute the calculated dimensions for plain ones and see if you still have the issue.

Hope this helps,

Jason

Re: Pivot Table Behaviour

richard_chilvers — Thu, 07 Feb 2013 15:47:24 GMT

Hi Jason

Yes, the User Preferences are set correctly.

I'm not sure about your comment on calculated dimensions. I suspect this might be a problem (I've experienced this type of behaviour before) but cannot see a way to eliminate them from my chart table - or are you suggesting eliminate them, just while tracking down the problem?

Regards

Richard

Re: Pivot Table Behaviour

Jason_Michaelides — Thu, 07 Feb 2013 15:49:16 GMT

Yes - that's what I'm suggesting. The erroneous behaviour may be due to the calculated dimensions. If that is the case - can you move the calculations into the script, or are they based on current selections?

Re: Pivot Table Behaviour

richard_chilvers — Thu, 07 Feb 2013 16:11:34 GMT

Thanks. I quickly tried your suggestion, but it made no difference. I cannot make the calculations in the script for the reason you say, so I will delve further into the dimension issue.

Richard

Re: Pivot Table Behaviour

Jason_Michaelides — Thu, 07 Feb 2013 16:13:23 GMT

Try recreating the pivot tables from scratch – they may have become corrupted. I am using this feature with no problems so far. V11 SR2

Re: Pivot Table Behaviour

richard_chilvers — Thu, 07 Feb 2013 17:08:06 GMT

Good idea. The table has had alot of development and on a precious occasion re-creating a table did sort out a similar issue with scrolling.

Thanks