2 Replies Latest reply: Feb 22, 2016 5:27 PM by Stefan Wühl RSS

    Waterfall Chart - How to display values on top of the segments

    swetha Nagireddy

      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:

      Waterfall.JPG

        • Re: Waterfall Chart - How to display values on top of the segments
          Oleg Troyansky

          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

          • Re: Waterfall Chart - How to display values on top of the segments
            Stefan Wühl

            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.