topic Re: Chart not resizing - silly question in QlikView

Chart not resizing - silly question

avastani — Wed, 29 Aug 2012 23:32:02 GMT

I have a simple line chart that has dates on dimension axis and sales on y-axis.

I get the chart drawn, but it cuts off after a certain date. It does not show me the entire trend chart over time. I have Size to Data selected, Allow Move/Size selected.

Typically, when I resize my charts, the last data point squeezes in always, but in this case I have to extend the chart all the way to the right.

I don't want to use the X-axis scrollbar as this will be printed in a report as PDF distribution, so it is important to have the chart fit FYTD data in a small space.

Any clues?

I also updated the Max values shows to 365 and it still doesn't show more than 100 data points for the dates

Re: Chart not resizing - silly question

sebastiandperei — Thu, 30 Aug 2012 00:26:14 GMT

Hi,

Select the object, and then press CTRL+SHIFT.

Now, you will see the different parts of the object in red squares. Keeping these keys pressed, you can resize these parts.

Re: Chart not resizing - silly question

avastani — Thu, 30 Aug 2012 00:27:25 GMT

tried that too, didn't work. i wonder if this is a bug with line or bar charts

Re: Chart not resizing - silly question

sebastiandperei — Thu, 30 Aug 2012 01:31:59 GMT

please, reduce and send the application...

Re: Chart not resizing - silly question

avastani — Thu, 30 Aug 2012 01:48:20 GMT

If I reduce the app, I lose the data I need. I can resize on Year, Quarter, Month, Week, but not on date.

Thanks.

Amir.

=====================

Amirali Vastani

Tel: 646.773.7936

Re: Chart not resizing - silly question

sebastiandperei — Thu, 30 Aug 2012 01:50:15 GMT

If you have a Day field, try to select one Day, so you will reduce, for example, all the data for the 1st day of each month...

How long is the size?

Re: Chart not resizing - silly question

avastani — Thu, 30 Aug 2012 01:52:32 GMT

The problem is that I am unable to show more than 100 data points on the chart. I try increasing the max values shown, but it doesn’t help. That’s the root cause. I know there is a 500 data point limitation with Block Chart, so don’t know if there is a similar 100 data point limitation/bug with line and bar graphs.

If I do X-axis scrollbar, I see them all.

Thanks.

Amir.

=====================

Amirali Vastani

Tel: 646.773.7936

Re: Chart not resizing - silly question

sebastiandperei — Thu, 30 Aug 2012 02:06:38 GMT

Ops, these are a lot of data points!!

Did you have tried tilding "Allow thin bars" and "Show all bars" boxes in Presentation of the object?

Re: Chart not resizing - silly question

avastani — Thu, 30 Aug 2012 02:07:32 GMT

Yes, but all to no luck.

Thanks.

Amir.

=====================

Amirali Vastani

Tel: 646.773.7936

Re: Chart not resizing - silly question

sebastiandperei — Thu, 30 Aug 2012 02:11:37 GMT

9000 values:

Re: Chart not resizing - silly question

avastani — Thu, 30 Aug 2012 02:15:20 GMT

So there is an upper limit. I wonder what it is. It is certainly not working for over 100 values

Thanks.

Amir.

=====================

Amirali Vastani

Tel: 646.773.7936

Re: Chart not resizing - silly question

Wed, 26 Mar 2014 18:28:53 GMT

I'm experiencing the same in v11.20. when trying to plot 130 values on a line chart...

In summary:

When reducing the horizontal size of the chart object with the plot in it, there comes a point where it stops crushing/shrinking the plotted line and dimension values get cut off/excluded (from the right). If I change axis into continuous, then the problem is fixed, i.e. the plot line gets shrunken/crushed as one would expect without excluding any dimension values. Actually some dimension labels get dropped since they don't fit (and in the end you end up with only two dimension labels shown that represent well the min and max range being plotted), but I still have all dimension values being plotted although their label isn't shown anymore.

However, when I use the continuous axis option, dimension values shown change into a number and I lose the user friendly labels, i.e. the field used as a dimension is loaded with the Dual() function. It has a "Year-WeekNo" text value and "WeekID" number that is a continously increasing integer value.

Any input from others on how to use a non-continuous axis and still have all dimension values squeezed in would be greatly appreciated. Or how to get the dimension values to cut off from the left (to lose the old values first) (BTW, so far I have not found that new v11 feature "Dimension Limits" can help on that front).

Enabling X-axis scrollbar does not show any scrollbar...

Re: Chart not resizing - silly question

Wed, 26 Mar 2014 22:51:04 GMT

Here is the workaround I found, I probably could have spent days, or forever, to find this trick:

Qlikview Bitz and Pieces: Qlikview - Line chart display trick to avoid horizontal scroll bar