Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
Scott2
Creator
Creator

2 Pivot Tables in a container - how to keep them close together when a filter is applied

Hi Qlik Community,

I am hoping you can help with the following issue.

Inside a container I have two pivot tables, one above the other. When the user applies some filters the vertical size of the pivots are reduced (due to the filter) as expected. 

However the user then has to scroll down the screen to get to the bottom pivot as it does not move up the screen to fill the space left by the top pivot now being smaller. 

Is there anyway to do this? 

thanks!

Scott

 

I have Two vizlib pivots in a container 1 pivot above the other on the page. When a filter is applied the both pivots are correctly filtered but as the top filter collapses smaller it means the bottom pivot does not move to be closer to the top pivot. i.e. the webpage is not dynamically re-positioning the lower pivot table up higher. Is there a setting or some CSS or something to make that happen? thanks

Labels (1)
1 Solution

Accepted Solutions
MartW
Partner - Specialist
Partner - Specialist

There is no way that you can make this happen in the current set up. 

you have created vizlib container. (with those containers you can show 2 or more vizualisation under or next to eachother.)

when you created the vizlib container you had to drag and drop this onto the canvas. this vizlib container object has a specific size 11 horizontal and 12 vertical see screenshot. this is the height and width of the object 

MartW_0-1705494975229.png

Here 12 is the vertical axis. So the vizlib container will be divided up into 2

that means that if you add a pivot table to both the container area's you basically create 2 pivot objects that are 6 vertical blocks tall.

if both (pivot) tables are filter to lets say only show 2 rows of data then there will be a huge gap between the 2 (screenshot 2) this gab exisits because the objects when filtered still have to keep the 6 blocks vertical space in mind.

MartW_1-1705495350597.png

the only thing what you can do is to change the layout from vertical to horizontal.

this will keep the pivot tables close to eachother but in a different form.

Hope this helps.

also you can try and look for you specific answers at the vizlib community. 

 

View solution in original post

2 Replies
MartW
Partner - Specialist
Partner - Specialist

There is no way that you can make this happen in the current set up. 

you have created vizlib container. (with those containers you can show 2 or more vizualisation under or next to eachother.)

when you created the vizlib container you had to drag and drop this onto the canvas. this vizlib container object has a specific size 11 horizontal and 12 vertical see screenshot. this is the height and width of the object 

MartW_0-1705494975229.png

Here 12 is the vertical axis. So the vizlib container will be divided up into 2

that means that if you add a pivot table to both the container area's you basically create 2 pivot objects that are 6 vertical blocks tall.

if both (pivot) tables are filter to lets say only show 2 rows of data then there will be a huge gap between the 2 (screenshot 2) this gab exisits because the objects when filtered still have to keep the 6 blocks vertical space in mind.

MartW_1-1705495350597.png

the only thing what you can do is to change the layout from vertical to horizontal.

this will keep the pivot tables close to eachother but in a different form.

Hope this helps.

also you can try and look for you specific answers at the vizlib community. 

 

Scott2
Creator
Creator
Author

thanks MartW for detailed explanation of the root cause.