Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator III
Creator III

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

Tags (2)
9 Replies
Highlighted
Master III
Master III

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

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

Highlighted
Creator III
Creator III

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

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

Highlighted
Master III
Master III

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

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.

Highlighted
Master III
Master III

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

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

Highlighted
Creator III
Creator III

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

11.2

Highlighted
Master III
Master III

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

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

How to fix pivot table's wide ?

Highlighted
Creator III
Creator III

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

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

Highlighted
Master III
Master III

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

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

Highlighted
Partner
Partner

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

Hi,

Share qvw so that we can check it.