topic annoying bar chart behaviour in QlikView

annoying bar chart behaviour

Wed, 26 Jan 2011 12:56:49 GMT

Hi all,

I have a simple bar chart in a qlikview 8.5 document that is just not doing what I want it to.

The dimension field is simply date, and the expression field is simply a 1 or a 0.

Here is my graph:

As you can see its simply a plot, over time, of whether or not a detection has occured on that date, represented by a 1.

Now while this looks fine above there are several issues with it.

Firstly, its not showing all the data. The data goes on to the right up to 19th Jan, but the graph is cutting it off, rather than fitting the data to the size of the graph. There is no way to change the static min, max and interval as the boxes are greyed out. If I stretch the graph out to the right, then more data displays but then the graph is too wide for the page.

Secondly, I have tried switching on and off various graph options to make it fit properly to the width. If I select 'continuous' on the dimension area of the axis tab, then the static min, max and interval become available. However the graph appears like this no matter what I do.

As you can see its doing something really odd with the axis.

I also tried using the thin bars setting:

Which is slightly better but still not fitting to the full width of the graph - its gone too far the other way now its gone from being too wide to not wide enough! And there is still no way to define an interval on the date axis (I wanted a 7 day interval), as its greyed out in the dialog.

Any help would be appreciated. There must be a setting Im missing it can't be that difficult to fit a graph and change the scale interval.

Thanks

Dan

annoying bar chart behaviour

Wed, 26 Jan 2011 14:49:10 GMT

Hi Daniel,

Please try the following ..

In the presentation tab of the chart --> Enable the "Max Visible Number (1-100) enter 15 as the value ..

And enable the option "show X-Axis Scroll bar...

Regards,

Chakravarthy.

annoying bar chart behaviour

Thu, 27 Jan 2011 10:28:46 GMT

Hi,

Thanks for your reply however I don't want to do that, I just want the graph to fit to the size of the screen and for me to be able to change the scale and interval to suit myself.

Thanks

annoying bar chart behaviour

lironbaram — Thu, 27 Jan 2011 10:53:18 GMT

hei

attach is an example

hope its helps you

annoying bar chart behaviour

kuba_michalik — Thu, 27 Jan 2011 12:10:06 GMT

Have you tried selecting both Thin Bars and Show All Bars? For some reason the first shows the chart too narrow, but selecting the second expands it again to fill the whole of the object.

annoying bar chart behaviour

Thu, 27 Jan 2011 13:00:25 GMT

Roiuser - thanks for this, ive tried to replicate the settings but it won't do the same thing as yours does.

Kuba - just tried this and it does this:

The bars now don't match to the scale underneith - eg the last one there which I have highlighted is the data point for the 30/12, but on the scale its over the 19/01 date.

annoying bar chart behaviour

suniljain — Thu, 27 Jan 2011 13:03:12 GMT

Your suggestion is in different direction . Actual problem is not because of that

Re: annoying bar chart behaviour

Rich-HHE — Thu, 09 Aug 2012 18:24:06 GMT

I know I'm replying to a post from 2011 but I'm experiencing the same in QV 11 SR1 problem as you did in 8.5, I believe, where the data bars get smushed and chopped. I just got off the phone with support and he said it was a known bug in 9 and fixed in 10. He was able to reproduce the error by having a continuous x-axis and has created a case and bug report.

I will post back here when they resolve the issue. Here is a shot of the problem with continuous x-axis and minimum and maximum values.

And here is the photo of the non-continous axis:

Edit: Here is the case description as entered by the tech:

When using a bar chart with the "Continuous" option checked in Axes and values set in the "Static Min" and "Static Max", values get left out and the bars are squished together and some overlap. Similar to bug 34083 back in v9

Re: annoying bar chart behaviour

Rich-HHE — Mon, 18 Feb 2013 15:29:10 GMT

They closed my ticket saying: "Unfortunately R&D has decided this is working as designed and will not be changing it." I can't believe this! This is completely unprofessional. What are we supposed to do when our bosses ask why we can't do a simple bar chart with continuous axes? We just say, sorry, although this feature can be found in almost ANY OTHER SOFTWARE, even the free OpenOffice, your $xx,xxx piece of software doesn't do it?

Re: annoying bar chart behaviour

Rich-HHE — Fri, 30 Jan 2015 21:09:55 GMT

Here I am again, 2 years later with the same problem. Using the latest version 11.20.12354.0 SR6 x64.

Amazing.

Re: annoying bar chart behaviour

DavidFoster1 — Tue, 07 Apr 2015 09:40:59 GMT

Suffering the same issue. I dont suppose you have had a breakthrough?

Re: annoying bar chart behaviour

DavidFoster1 — Tue, 07 Apr 2015 09:41:38 GMT

Suffering the same issue. I dont suppose you have had a breakthrough?

Re: annoying bar chart behaviour

Rich-HHE — Tue, 07 Apr 2015 11:53:18 GMT

I have not. Sorry.

Re: annoying bar chart behaviour

DavidFoster1 — Tue, 07 Apr 2015 12:09:09 GMT

I have raised it as a partner support case. Fingers-crossed I get more traction.

Re: annoying bar chart behaviour

ladislav — Fri, 13 Nov 2015 07:40:57 GMT

Same issue here. It is so frustrating not to be able to do simple bar chart!!

Re: annoying bar chart behaviour

DavidFoster1 — Thu, 26 Nov 2015 12:58:13 GMT

Got no traction whatsoever 😞

Re: annoying bar chart behaviour

Lucas1 — Fri, 20 Aug 2021 08:43:24 GMT

Dear Dan,

I've noticed your images are gone - but maybe you are still looking for a solution.

You need to add an expression which calculates everytime and select none of the display options.

Expression: 1

Calculates for every dimension. And I hope it is a very low calculation as well.

I think the issue is, imagine your chart as a table, you only calculate a few dimensions and generate a rather small table, which leads QlikView to get the impression that bars could be drawn wider. The minimum dimesion is only applicable for charts and continues axes - for tables QV would cutoff every unused dimension.

Still, this is a workaround in my opinion.

Hope you aren't looking for the solution at all since, you asked 10 years ago 🙂

Re: annoying bar chart behaviour

Lucas1 — Tue, 05 Oct 2021 05:03:55 GMT

I need to add:
If one dimesion is filtered so that nothing is calculated over the x axis this won't work. Then you would need to make a calculation w/ set expression {1} something like

Count({1} Cost).

Point is you want a calculation that works for the entire x axis, but isn't shown.