1 Reply Latest reply: Dec 28, 2016 2:00 PM by John Witherspoon RSS

    Display the % and the count in a bar chart

    Twan Peters

      I want to display in 1 bar chart the % and the count, the same as in the attached graph.

       

      Is that possible in Qlikview without adding a text object above the graph?

        • Re: Display the % and the count in a bar chart
          John Witherspoon

          Yes, you can make your expression something like the below, and show values on data points:

           

          dual(the text you want to see here, your current expression for the bar height here)

           

          So maybe something like:

           

          dual(num(count(Something)/1000000,'#,##0')&'M
          '&num(count(Something)/count(total Something),'#,##0%'),count(Something))

           

          You won't be able to get different font sizes, though, or at least I'm not thinking of a way to do so.