Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Partner
Partner

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
Highlighted
MVP & Luminary
MVP & Luminary

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

Try this,

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

Regards,

Kaushik Solanki

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
Highlighted
Partner
Partner

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

Thanks about the answer..but same result

Highlighted

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

Uses Fabs() function

Highlighted
Partner
Partner

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

its doesn't work..

Highlighted
Partner
Partner

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

Hi ,

Please share a sample application.

Thanks

Raja

Highlighted
Contributor

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

Hello Shahar,

PLease find the .qvw.

Hope this help!