Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

Re: Reverse a Horizontal Bar Chart.

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

22 Replies
Highlighted

Re: Reverse a Horizontal Bar Chart.

I think you cannot

Highlighted
MVP
MVP

Re: Reverse a Horizontal Bar Chart.

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

Highlighted
Specialist II
Specialist II

Re: Reverse a Horizontal Bar Chart.

Are you trying to do something like this?

Age_Band.png

Highlighted
Creator
Creator

Re: Reverse a Horizontal Bar Chart.

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

Highlighted
Creator
Creator

Re: Reverse a Horizontal Bar Chart.

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.

Highlighted
Luminary
Luminary

Re: Reverse a Horizontal Bar Chart.

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

Highlighted
Creator
Creator

Re: Reverse a Horizontal Bar Chart.

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.

Highlighted
Creator
Creator

Re: Reverse a Horizontal Bar Chart.

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

Highlighted
Specialist II
Specialist II

Re: Reverse a Horizontal Bar Chart.

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