Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pgriffiths
Creator
Creator

Reverse a Horizontal Bar Chart.

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.

Qlikview Reverse Horizontal Bar Chart.png

1 Solution

Accepted Solutions
ThornOfCrowns
Specialist II
Specialist II

Hi,

I think I have kind of bodged something together:

Reverse.png

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!

View solution in original post

24 Replies
alexandros17
Partner - Champion III
Partner - Champion III

I think you cannot

MK_QSL
MVP
MVP

Not really possible but obviously ! you can play with some trick...

ThornOfCrowns
Specialist II
Specialist II

Are you trying to do something like this?

Age_Band.png

pgriffiths
Creator
Creator
Author

I wasn't but it would work well like that.

pgriffiths
Creator
Creator
Author

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.

richard_pearce6
Luminary Alumni
Luminary Alumni

You could look at using offset Peter, alhtough I'm not sure you can allign the values to the left

pgriffiths
Creator
Creator
Author

I have created two charts and put them into a container and it get me very close.

Below is an image of the result.

Qlikview Reverse Horizontal Bar Chart2a.png

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.

  • CHART WITH ONLY BARS
    [Caption] Untick "Show Caption"
    [Layout] Set "Border Width" to 0pt
    [Dimensions] Untick "Label"
    [Dimensions] Untick "Show Legend"
    [Expressions] Create a negative of your existing expressions and promote to the top.
    My original expression had a label of CountAssigned
    So my new expressions "Definition" was the following

    =-[CountAssigned]

    I called the new expression NegativeCountAssigned
    • With NegativeCountAssigned expression selected.
      Tick "Bar"
      Untick "Values on Data Points"
      Untick "Expressions as Legend"
    • With CountAssigned expression selected.
      UnTick "Bar"
      tick "Values on Data Points"
      Untick "Expressions as Legend"
  • Produce the Dimension only
    [Caption] Untick "Show Caption"
    [Layout] Set "Border Width" to 0pt
    [Expressions] Untick "Values On Data Points"
    [Axes] Tick "Hide Axis" for the expression
    [Axes] Tick "Static Min" then enter a value of -1
    [Axes] Tick "Static Max" then enter a value of -1
    [Axes] Untick "Truncate Label" <-(Seems to force left justification on the dimension.)
  • Container.
    Enter the relevant chart name, caption colour and font in the [Caption] tab.

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.

pgriffiths
Creator
Creator
Author

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?.

ThornOfCrowns
Specialist II
Specialist II

The Male numbers are multiplied by -1 to give false negative numbers.