Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
shahar_potash
New Contributor

Show the total value at the top of stacked bar chart

I want to show the total value on the top of the stacked bar chart.

I created an expression that sums the columns of the chart

(expression= cloumn(1)+cloumn(2)+column(3)...) and in the display options menu i ticked on the "Values on Data Point" option.

It works fine and i see the total value at the top of the stacked bar, but when some of the columns have a negative value i see the total value at the bottom of the stacked bar in addition to the top.

I want to show the total value only at the top of the staked bar even when some of the column have a negative value.


Any idea?

6 Replies

Re: Show the total value at the top of stacked bar chart

Try this,

Fabs(Column(1) + column(2) + column(3))

Regards,

Kaushik Solanki

shahar_potash
New Contributor

Re: Show the total value at the top of stacked bar chart

Thanks about the answer..but same result

Re: Show the total value at the top of stacked bar chart

Uses Fabs() function

shahar_potash
New Contributor

Re: Show the total value at the top of stacked bar chart

its doesn't work..

arasaraja_cts
New Contributor III

Re: Show the total value at the top of stacked bar chart

Hi ,

Please share a sample application.

Thanks

Raja

rohitraut
Contributor

Re: Show the total value at the top of stacked bar chart

Hello Shahar,

PLease find the .qvw.

Hope this help!

Community Browser