Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Accepted Solutions
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.
vs
Still, this is a workaround in my opinion.
Hope you aren't looking for the solution at all since, you asked 10 years ago 🙂
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.
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