16 Replies Latest reply: May 13, 2016 1:26 PM by Clever Anjos

# Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

Hi All,

Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot.

I Attached example screen which i need to show

Can any one help me to solve

Thanks,

AR UMAMAHESH

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

As long you have only one expression, yes

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

Thanks Anjos,

Yes only one expression i putted

Can you share the logic because i am using personal edition

Thanks

AR UMAMAHESH

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

Thanks Anjos,

Yes only one expression i putted

Can you share the logic because i am using personal edition

Thanks

AR UMAMAHESH

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

dual(

Dim2 & chr(10) &  sum(Expression1),

sum(Expression1)

)

• Stack your graph (at Style tab)
• Check "Values on data points" (at Expression tab)
• Check "Plot Values inside segments" (at Presentation tab)
• Check "Expression Defaul" (at Numbers tab)
• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

"Plot Values inside segments" (at Presentation tab) select that one than you can get that one.

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

first select bar chart  and two dimensions and select the next button in the style button to select the stacked button and in presentation tab to select the plot point value than select the finish button than you can the out put

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

Hi thanks,

But I didn't get the total values on top of the bar, I need to display total value along with inside segments also

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

Thank You so much Anjos,

Thanks

AR UMAMAHESH

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

Funny, you did with my help and marked another one as "correct"

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

Oh, Sorry

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

No problem, just kidding.

"Don´t worry, be happy"

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

Hi Anjos,

Can you help me again in this same issue. I need to display total value at the top. In Qlikview 11.2 there is no option to display total values at top, I can I do this, I need to show total value of the first dimension in the above chart

Thanks

AR UMAMAHESH

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

If you´re using Version 12, just check "Still Show Total on Top" at presentation tab

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

Ya I checked

In 12 there is direct option

In my work area we use 11.2

now I used text in chart with condition on the top of every dimension in presentation tab

Is there any dynamic way to show in 11.2

AR UMAMAHESH

• ###### Re: Can we have chance to create a Stacked bar chart with two dimensions along with second dimension values inside the plot

I´m not sure it´s possible.

I´ve tryied to include a second expression and use as symbol, but in this case (2D & 2E) stacking is unavailable.

Is it a problem to upgrade to 12?