topic Hanging Bars in Bar Chart Based on % in QlikView

Hanging Bars in Bar Chart Based on %

Sat, 31 Dec 2011 12:35:46 GMT

Dear All Champs,

Happy New Year to Every One

I have 2 scenarios

1. Making Hanging Bars in Bar Chart.

2. Stack Bars in Bar Chart

I am attaching a sample excel. please suggest me that how I can do it.

Sorry If I am trying to do some stupid things.

Thanks In Advance.

anil

Hanging Bars in Bar Chart Based on %

swuehl — Sat, 31 Dec 2011 13:52:01 GMT

A hanging bars chart is also called "waterfall chart", there are some examples here in the forum, please search for waterfall chart (then you find e.g. http://community.qlik.com/message/31457).

A stacked bar chart is also possible, you could create an expression per segment and select style "stacked" in style tab of bar chart properties. Again, I think there are a lot of examples here, please search for stacked bar chart.

Hanging Bars in Bar Chart Based on %

Sat, 31 Dec 2011 13:56:49 GMT

Thanks for your suggestions. now I will check it.

Wishes For New Year - 2012

- anil

Re: Hanging Bars in Bar Chart Based on %

Sat, 31 Dec 2011 14:11:58 GMT

hi, swuehl

this message is deleted. can you tell me another one or can you tell from where i can see the Bar Offset functionlatiy of expression definition

- anil

Hanging Bars in Bar Chart Based on %

swuehl — Sat, 31 Dec 2011 14:20:01 GMT

Sorry, which message is deleted? If you refer to my above link, I can still access it..

Here is another one:

http://community.qlik.com/message/32390

Basically, you could create a set of expressions, one for total, the other for the subtotals. The subtotals baselines are offset using the expression attribute (expression tab - click on the plus sign next to the expressions - bar offset).

The offset is determined by the total minus the sum of expression values up to this bars expression.

Re: Hanging Bars in Bar Chart Based on %

Sat, 31 Dec 2011 14:25:48 GMT

Thanks Sir,

I got it and It is working.

anil