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: 
Anonymous
Not applicable

V.11.2 Pivot Table resizing when selection is made from list box

I have a pivot table, something like below.Anytime I select from a list box my chart columns resizes to the selection. I want to keep the view as is with no selections. Is there a way to prevent the resizing?

Central Division                                         North Division

Central east    Central West                         North east   North west

9 Replies
Digvijay_Singh

You may need to use {1} set identifier in your expressions to ignore selections.

Anonymous
Not applicable
Author

I don't want to ignore the selections. I just want to keep the chart the same size when selecting from my list boxes.

Digvijay_Singh

Which version you are using, I was just checking in version 12, the demo app 'Data Visualization' which comes along with desktop edition  and could see that column size is not changing when selecting values from list box, in fact showing 3 dots ... when value length is higher than column size.

Digvijay_Singh

Sorry, just got that you mentioned ver no in the subject

Anonymous
Not applicable
Author

11.2

Digvijay_Singh

See if Unchecking  'size to data' in pres tab helps -

How to fix pivot table's wide ?

Anonymous
Not applicable
Author

It doesn't. I have also tried sheet properties--->security properties uncheck "Move size sheet objects"

Digvijay_Singh

Not sure then hope others will help you out on this, if you are using Ajax client then someone else also faced similar issue -

Resizing columns in Ajax

krishnacbe
Partner - Specialist III
Partner - Specialist III

Hi,

Share qvw so that we can check it.