Discussion Board for collaboration on QlikView Layout & Visualizations.
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.
Fabs(Column(1) + column(2) + column(3))
Thanks about the answer..but same result
Uses Fabs() function
its doesn't work..
Please share a sample application.
PLease find the .qvw.
Hope this help!