Sizing of Pivot Table : dynamic border / horizontal scrollbar
Hello Qlikview guys
I'm facing an issue related to the size of my pivot chart.
This chart has X default dimensions on the left, and 1 default expression on the right.
Then, by checking a checkbox outside the table, other dimensions and other expressions are added to the table, respectively to the left and to the right sides.
My issue is that I want the right border of the pivot chart to follow the additional columns.
Currently,
- either I have a fix border that is too expanded (size to data unchecked) : when I add the optional columns it's perfect, but when I uncheck the option, I have a half-empty rectangle (or half-full ).
- or I have a dynamic border that is expanded with the optional columns (size to data checked), BUT the additional expressions on the right create a scrollbar whereas I would like the table to be completely expanded in order to have them all visible.
Is there some option to disable the scrollbar expression? Or to expand more?