Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am working on a waterfall chart and have a question on how to display the values on top of the bars/segments always even when the value drops?
For all the highlighted values below how do we get them to display on top of the bar??
Screenshot below:
Hi,
in my practice, I usually present Waterfall charts using positive amounts and manage their direction (up or down) by calculating the offset accordingly. This way, all bars carry positive numbers, and the numbers are always presented on top of the bars.
You can also try experimenting with Dual() values - your numeric value can be positive, while text representation may look like negative.
Finally, you can experiment with an extra set of Expressions - those with no visual Representation, except for "Values on Data Points".
Learn these and many other advanced development techniques from my new book QlikView Your Business.
Cheers,
Oleg Troyansky
You probably need to check if your value is negative, then multiply by -1 to get a positive number.
Positive numbers are shown on the top, negative on the bottom of a bar chart.
You may need to adjust the bar offset to take care of the changed sign as well as creating a dual value with a text representation that shows your negative original value as text.