Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am new to Qlikview so please go easy.
As I have had no luck with the Parallel Coordinate chart, I thought I would use two bar charts to show the number of calls assigned in and out of a team instead.
To do this I need to reverse a horizontal bar chart for one half of my data.
I need the Dimension Axes on the right and the Bars to run from right to left.
I have attached an image to show what I mean, I created this in Ms Paint so you can see what I am after.
The first chart is normal and the second chart is what I want to achieve.
Is there any way to do this as I have been looking for a couple of hours now with no joy
Many thanks.
Hi,
I think I have kind of bodged something together:
It is one chart and it doesn't need a container or floating overlays / text boxes. It does use the "Vertical Labels" trick I picked up from the Community - blog . qvapps . com/2010/09/10/qlikview-tutorial-vertical-labels-inside-bars/
Chart is a standard Combo chart
Dimension in my case is ReferralReasonDesc
Expression 1 is -Count(ReferralID) shown as bar, enabled. Values on Data Points UNticked
Expression 2 is Dual(ReferralReasonDesc, 1) as symbol, enabled and invisible. Values on Data Points ticked
Expression 3 is Dual((count(ReferralId)), count(ReferralId)-(2*(count(ReferralId)))) as symbol, enabled and invisible. Values on Data Points ticked
Chart is sorted by Y-value, Ascending
Expression 2 puts the text at the 0 value
Expression 3 puts the numbers at the end of the bars
Hope this helps!
I think you cannot
Not really possible but obviously ! you can play with some trick...
Are you trying to do something like this?
I wasn't but it would work well like that.
I like this Kachhia, gets me very close.
I count use two graphs in a container, one like yours for the bars and suppress the Dimensions axis names and one for the Dimension axis names and suppress the bars.
You could look at using offset Peter, alhtough I'm not sure you can allign the values to the left
I have created two charts and put them into a container and it get me very close.
Below is an image of the result.
The first chart shows only the bars. The bars are created with negative values and the values at the end of the bars is a second expression.
The second chart shows only the Dimension Axis names.
Here are the steps I took.
I think that about covers it.
I end up with white space on the right side of the chart, but end up with what I wanted.
Hi James,
I had a go at this, but my blue and pink bars are showing my expressions are on different rows.
How did you get the two expressions to show on the same row?.
The Male numbers are multiplied by -1 to give false negative numbers.