topic Re: Reverse a Horizontal Bar Chart. in QlikView

Reverse a Horizontal Bar Chart.

pgriffiths — Wed, 09 Jul 2014 09:45:40 GMT

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.

Re: Reverse a Horizontal Bar Chart.

alexandros17 — Wed, 09 Jul 2014 09:58:41 GMT

I think you cannot

Re: Reverse a Horizontal Bar Chart.

MK_QSL — Wed, 09 Jul 2014 10:07:39 GMT

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

Re: Reverse a Horizontal Bar Chart.

ThornOfCrowns — Wed, 09 Jul 2014 10:33:18 GMT

Are you trying to do something like this?

Re: Reverse a Horizontal Bar Chart.

pgriffiths — Wed, 09 Jul 2014 11:02:23 GMT

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

Re: Reverse a Horizontal Bar Chart.

pgriffiths — Wed, 09 Jul 2014 11:05:09 GMT

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.

Re: Reverse a Horizontal Bar Chart.

richard_pearce6 — Wed, 09 Jul 2014 11:21:58 GMT

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

Re: Reverse a Horizontal Bar Chart.

pgriffiths — Wed, 09 Jul 2014 13:51:19 GMT

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.

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.

Re: Reverse a Horizontal Bar Chart.

pgriffiths — Wed, 09 Jul 2014 14:21:10 GMT

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

Re: Reverse a Horizontal Bar Chart.

ThornOfCrowns — Wed, 09 Jul 2014 14:22:24 GMT

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

Re: Reverse a Horizontal Bar Chart.

pgriffiths — Wed, 09 Jul 2014 14:29:24 GMT

I managed to get that far, but they show on different rows, not the same row. Any idea why?.

Re: Reverse a Horizontal Bar Chart.

Wed, 09 Jul 2014 14:54:54 GMT

use 'Stacked ' in the Style > subType

Re: Reverse a Horizontal Bar Chart.

ThornOfCrowns — Wed, 09 Jul 2014 15:11:13 GMT

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!

Re: Reverse a Horizontal Bar Chart.

richard_pearce6 — Wed, 09 Jul 2014 15:17:08 GMT

Hi Peter,

Sorry, had to check my original thought around alligning values and you can do it using a dual() function.

Dual( Bar Value , Chart Possition)

http://community.qlik.com/message/455896#455896

Richard

Re: Reverse a Horizontal Bar Chart.

ThornOfCrowns — Wed, 09 Jul 2014 15:19:38 GMT

Richard Pearce That's exactly the trick I used in the chart below, twice in fact!

Re: Reverse a Horizontal Bar Chart.

Wed, 09 Jul 2014 15:24:16 GMT

do you mind posting the trick here to achieve that ? might be helpful for all.

Re: Reverse a Horizontal Bar Chart.

ThornOfCrowns — Wed, 09 Jul 2014 15:30:49 GMT

Have just edited the post, My QV

Re: Reverse a Horizontal Bar Chart.

richard_pearce6 — Wed, 09 Jul 2014 15:35:14 GMT

🙂 It's a cool trick, I only just found it because I wanted to confirm my orignal comment (which it turns out I was too hasty to say it can't be done - I should have known better 🙂 )

Cheers James !!

Re: Reverse a Horizontal Bar Chart.

Wed, 09 Jul 2014 15:47:00 GMT

very well done .. thanks James

Re: Reverse a Horizontal Bar Chart.

pgriffiths — Wed, 09 Jul 2014 17:00:27 GMT

That works great and gives me a few new toys to play with also.

Many thanks James and everyone else for their help.