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

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

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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

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

Digvijay_Singh — Thu, 16 Jun 2016 17:03:54 GMT

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

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

Anonymous — Thu, 16 Jun 2016 17:06:04 GMT

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

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

Digvijay_Singh — Thu, 16 Jun 2016 17:20:37 GMT

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.

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

Digvijay_Singh — Thu, 16 Jun 2016 17:22:10 GMT

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

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

Anonymous — Thu, 16 Jun 2016 17:22:18 GMT

11.2

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

Digvijay_Singh — Thu, 16 Jun 2016 17:29:09 GMT

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

How to fix pivot table's wide ?

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

Anonymous — Thu, 16 Jun 2016 17:33:01 GMT

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

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

Digvijay_Singh — Thu, 16 Jun 2016 18:23:54 GMT

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

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

krishnacbe — Thu, 16 Jun 2016 18:40:34 GMT

Hi,

Share qvw so that we can check it.