Barchart Stacked Problem

[Anil_Babu_Samineni]

Hello,

can anyone help me this Chart. I am try to create butterfly chart...

I want to Stacked the data in this chart...! Unfortunately, this is not working. i tried all ways which i know ..!

Can you please share me your Thoughts as well...!

Please find this Graph ...!

In that qvw i am trying to apply the Client Sheet. Please have a look and share me the correct way. If you want anything please let me know so that i can reply ASAP...

I Appreciate your help...!

[swuehl]

Maybe like attached, using negative expressions and removing the bar offset attribute expression.

[kamal_sanguri]

you have to distribute count of types in two different columns.. two expression would be required to create a butterfly chart.. !!

This link should be helpful:

how to show percentage data in age pyramid bar chart?

[Anil_Babu_Samineni]

Hey Perfect,

Thanks for attempting. Can i know left of two did you change anything ..

I deleted my Bar offset expression and I apply the Negative expression. did you change Anything else..!

Updated : Here, I mention two graphs. So, User looking only one graph like KAMAL qvw.

[Anil_Babu_Samineni]

Kamal,

Can you please apply my graph and then share it to me. And client want only one graph. In my graph i created two graph above one is Hires and below one is Leavers. So, i want to show one graph only..

Can you please work on my qvw...!

Take Swuehl qvw....!

[swuehl · Accepted solution]

anil babu wrote:

Hey Perfect,

Thanks for attempting. Can i know left of two did you change anything ..

I deleted my Bar offset expression and I apply the Negative expression. did you change Anything else..!

Updated : Here, I mention two graphs. So, User looking only one graph like kumar qvw.

In addition, I changed the style to 'stacked'

[Anil_Babu_Samineni]

Thanks,

But, i take two graphs here. So, Client want to show single graph only..

1) Hires graph   2) Leaver graph.

So i want to create one graph with these two graphs...

If possible, Please take Variable and then create for me.

Please help me....

[kamal_sanguri]

Please look at sheet 3.. still I think you need some changes in your data model..

[kamal_sanguri]

Add year/date column in Attrition_Data table, so that leaver and hires can be distributed and be presented in chart.

[kamal_sanguri]

I think we can use Exit Year from other table..look at the modified one..