topic Re: Barchart Stacked Problem in QlikView

Barchart Stacked Problem

Anil_Babu_Samineni — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Barchart Stacked Problem

swuehl — Wed, 01 Jun 2016 10:07:31 GMT

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

Re: Barchart Stacked Problem

kamal_sanguri — Wed, 01 Jun 2016 10:10:59 GMT

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?

Re: Barchart Stacked Problem

Anil_Babu_Samineni — Wed, 01 Jun 2016 10:14:35 GMT

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.

Re: Barchart Stacked Problem

Anil_Babu_Samineni — Wed, 01 Jun 2016 10:17:19 GMT

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

Re: Barchart Stacked Problem

swuehl — Wed, 01 Jun 2016 10:25:36 GMT

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'

Re: Barchart Stacked Problem

Anil_Babu_Samineni — Wed, 01 Jun 2016 10:28:40 GMT

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

Re: Barchart Stacked Problem

kamal_sanguri — Wed, 01 Jun 2016 10:36:44 GMT

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

Re: Barchart Stacked Problem

kamal_sanguri — Wed, 01 Jun 2016 10:39:30 GMT

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

Re: Barchart Stacked Problem

kamal_sanguri — Wed, 01 Jun 2016 10:57:21 GMT

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

Re: Barchart Stacked Problem

Anil_Babu_Samineni — Wed, 01 Jun 2016 10:58:03 GMT

Did you understand My question?

You share me this, Right - AgePyramid_2.qvw

Swuehl share me this - Attrition_2.qvw

I am fine for this Attrition_2.qvw -- So, Please work on the same file from the client sheet.

So, here i want to show one graph. Did you get a chance to look see the Attachment of Swuehl. Here, i want to show one graph only. In that graph, it showing two graphs.. After finishing the graph when i move that graph to another place whole graph will move. That is my client looking like you share the first one...

Re: Barchart Stacked Problem

Anil_Babu_Samineni — Wed, 01 Jun 2016 13:20:16 GMT

Hello Sir,

Can you please let me know.

If i click on second graph( I Mean bottom one) i want to hide top one and bottom one placed to the top one.

So after that, I want to show only bottom graph with in the top graph only...

Re: Barchart Stacked Problem

swuehl — Wed, 01 Jun 2016 13:44:07 GMT

Maybe create a button that toggles a variable and then use show conditions in layout tab for your charts based on the variable.

Re: Barchart Stacked Problem

kamal_sanguri — Wed, 01 Jun 2016 14:19:20 GMT

Pls find attached..

Re: Barchart Stacked Problem

Anil_Babu_Samineni — Wed, 01 Jun 2016 14:47:51 GMT

Client don't want to create any buttons here. When ever we click on second graph she want to hide first graph only. And then she want to show the second graph replace to first graph..

I really appreciate your help.

If possible can you please share me the button one as well...

Re: Barchart Stacked Problem

Anil_Babu_Samineni — Wed, 01 Jun 2016 18:35:17 GMT

Hi,

Did you get a chance to look this..

Is anyone, Find this...

Re: Barchart Stacked Problem

Anil_Babu_Samineni — Wed, 01 Jun 2016 18:35:44 GMT

Kamal,

Did you find this...!