topic Re: Reverse chart bar in QlikView

Reverse chart bar

Tue, 31 Jan 2012 16:23:38 GMT

Hi everyone,

I'm looking for a method to reverse a chart bar meaning that if I have a linear gauge chart that fills to value I want that my bar starts at the variable value and goes to 100%.

I attached a document which explains in more detail what I try to do.

Thanks a lot.

Re: Reverse chart bar

Anonymous — Tue, 31 Jan 2012 18:45:45 GMT

Hi One solution would be to cover everything up to the variable value with use of a white gauge, and have a condition set background color as background in the expression that would make it look like a linear gauge. Did you try this? /Marcus

Reverse chart bar

Wed, 01 Feb 2012 09:23:12 GMT

Hi Marcus,

I try to do this exactly the other way around so that the white gauge chart covers the now uncovered part of the bar.

It is used to show the level of fulfiment, so if the value is 60% than only 60% of the bar should be filled with color.

I hope I made it clearer now, what I try to do?

Re: Reverse chart bar

Anonymous — Wed, 01 Feb 2012 10:15:15 GMT

Hi,

I did something ones with images that i named with numbers, something like the example i added here. Maybe it is something you can consider?

Reverse chart bar

Wed, 01 Feb 2012 10:19:12 GMT

I cannot see the images . So I don't know what you did there

It still has to be an interactie chart as the numbers will change.

Re: Reverse chart bar

Anonymous — Wed, 01 Feb 2012 10:21:50 GMT

Sorry, i forgot you need to have the images there also, hehe. Here you have the whole folder.

Reverse chart bar

Wed, 01 Feb 2012 10:26:57 GMT

Still not working but I know what you did now.

It's an option but as I have 20steps this is a lot of work to format this.

But thanks!!

Re: Reverse chart bar

Anonymous — Wed, 01 Feb 2012 13:40:46 GMT

Strange, anyway this is how it would look.

Reverse chart bar

Wed, 01 Feb 2012 13:43:10 GMT

Thanks!

Re: Reverse chart bar

Wed, 30 Sep 2015 14:56:32 GMT

Hello,

I think I’m having the same problem, in QlikView I built a chart bar (like number 1) and I want transpose the chart like number 2, having the kip’s in the x axis and dimensions in the y axis . The image is an example from Excel; you can switch row/column.