topic Re: Prevent a Bar Chart's Dimension Resizing in QlikView

Prevent a Bar Chart's Dimension Resizing

Wed, 06 Jul 2016 13:32:37 GMT

I have a bar chart and I want the X axis to remain the same size even when the user selects part of the chart.

Re: Prevent a Bar Chart's Dimension Resizing

arasantorule — Wed, 06 Jul 2016 14:15:24 GMT

Hi,

Can you explain the requirements in detail.

are you expecting a scroll bar in the bar chart to always show limited number of values in X axis.

Thanks.

Re: Prevent a Bar Chart's Dimension Resizing

Wed, 06 Jul 2016 14:39:40 GMT

For an X axis ( the dimension), the chart has a series of dates (MMM-YYYY). When nothing is selected, the X axis stretches from Febuary 2010 to Feb 2016 (see image 1). If I select a section of the data that only takes place between May 2012 and Nov 2013, the bar chart will resize the X axis so that it starts at May 2012 and ends at Nov 2013 (see image 2). I don't want this to happen.

Instead, I want the bar chart's X axis to remain at Feb 2010 to Feb 2016 when the data is selected, sot that it gives a sense of the timeframe that the data happened within.

Re: Prevent a Bar Chart's Dimension Resizing

boorgura — Wed, 06 Jul 2016 14:46:59 GMT

Try setting static limits to the AXES in the Axes tab of chart properties

Re: Prevent a Bar Chart's Dimension Resizing

boorgura — Wed, 06 Jul 2016 15:23:20 GMT

In the Axes tab of chart properties:

Under Dimension Axis (bottom half)

Select "Continous" (check box)

and then enter Scale values: Static Min, Static Max and if needed Static Step.

Re: Prevent a Bar Chart's Dimension Resizing

antoniotiman — Wed, 06 Jul 2016 15:33:47 GMT

Hi Cael,

in Your Expression use

{<MonthYearField=>}

Sum({<MonthYearField=>} Value)

Regards,

Antonio