Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
jitu2110
Creator
Creator

Pivot Table Vertical Scrollbar Issue

Hi Team,

i have created a fixed size pivot table, and also disabled move/size of table and size to data options in layout.

i also have around 6-7 dimensions those are sufficient enough to extend my table size beyond the size what i have define.

When all dimensions are collapsed its look good but when we extend all its increase  the size of the table.

its also happening because the vertical scroll bar appears/start from the position of Expression only. but i strictly want to use pivot chart only on limited and workaround . ( Even Container is helping to restrict size of my table but expression is getting hide under the container.)


i want the table should fixed under Quick facts text box only.

Verticalscroll.png

IS there any other options so the pivot table have vertical scroll bar starts from the begging of the chart on expression.

2 Replies
jitu2110
Creator
Creator
Author

Any Help

marcus_sommer

The real size of an object could be seen and adjusted (activating the object showed their max. size with black borders which could be dragged) within the draft-mode (menu --> tab view --> the third from bottom).

But AFAIK the scrollbars couldn't be adjusted in any way - they will be always displayed with the object-size is to small for the content.

A workaround for you could be to use two objects - a smaller one which is adjusted without scrollbars and a bigger one which is adjusted with scrollbars (some columns must be smaller for this) - and to control this per visibility-condition on the max. number of dimension-values with something like: count(distinct Dim1 & Dim2 & Dim3 ...). It won't probably work in each possible situation for example by using partial sums but it will be probably the nearest what you could get.

- Marcus