topic Re: Bar Chart Overlap in QlikView

Bar Chart Overlap

Anonymous — Tue, 24 Nov 2015 07:23:42 GMT

Hi All,

I create a bar chart with Agent as a dimension and Referrals ,Ai, Closed, Declined are expressions(these are related to agent).In style I selected stacked view it is displaying as shown in image every bar is just added to below bar I don't want to display like that.

every expression bar has to be start from 'o'.

Please anyone help me. It's an urgent requirement in my project.

Thanks in advance

Thanks

Anusha K

Re: Bar Chart Overlap

swuehl — Tue, 24 Nov 2015 07:37:29 GMT

Maybe just change the style to grouped?

Re: Bar Chart Overlap

Tue, 24 Nov 2015 07:37:53 GMT

Hi Anusha,

I think buy using combo chart to display two expression,

But i don't know three expressions

Re: Bar Chart Overlap

Anonymous — Tue, 24 Nov 2015 07:44:02 GMT

Hi swuehl,

Thanks for ur reply but want to display in stacked view only

Re: Bar Chart Overlap

Anonymous — Tue, 24 Nov 2015 07:46:33 GMT

Thankyou ramanjaneyulu but I need to display in stacked view of barchart only with 4 expressions

Re: Bar Chart Overlap

Tue, 24 Nov 2015 07:57:49 GMT

Hi anusha,

in my knowledge of qlikview that is not possible directly

Re: Bar Chart Overlap

swuehl — Tue, 24 Nov 2015 08:06:42 GMT

Maybe I just don't understand what you want as result. Could you post a sketch of the desired outcome?

Re: Bar Chart Overlap

Anonymous — Tue, 24 Nov 2015 08:20:51 GMT

Hi swuehl,

I want the result like in below image.

Re: Bar Chart Overlap

Mark_Little — Tue, 24 Nov 2015 08:26:40 GMT

Hi,

I have a play and like thought it is not possible as standard, You maybe able to acheive this by overlapping graphs on top of each other, but highly unlikely due to figures not always suiting this, i.e. highest values at the back. An extension object made be able to be built to do this, but again there would be issues with ordering.

Mark

Re: Bar Chart Overlap

swuehl — Tue, 24 Nov 2015 08:27:30 GMT

I think you need to manipulate your expressions, that first expression is

=Sum(Field1)

second:

=Dual(Sum(Field2), Sum(Field2) -Sum(Field1) )

third:

=Dual(Sum(Field3), Sum(Field3) -Sum(Field2) -Sum(Field1) )

etc.

You'll need to ensure that first expression results always in value < second expression, and second is always smaller than third etc.

Re: Bar Chart Overlap

settu_periasamy — Tue, 24 Nov 2015 08:32:11 GMT

Hi,

Check this link.. May be helps..

Stacked Bar Chart - Actual vs Budget

Re: Bar Chart Overlap

krishna20 — Tue, 24 Nov 2015 08:34:37 GMT

Hi,

Refer this link

Stacked Bar Chart Sorting

Re: Bar Chart Overlap

Anonymous — Tue, 24 Nov 2015 09:10:01 GMT

currently I am using these expressions only but in some cases it gives the '-ve' values so, I think this is not the proper way to achieve this.