7 Replies Latest reply: Oct 5, 2016 4:06 PM by Caio Lobato Gil Goncalves RSS

    Bar Chart with number and percentage

    Caio Lobato Gil Goncalves

      Hi,

       

      I need to create a bar chart in Qlik Sense, something like that:

       

      Sem título.png

      So as you can see there is two values in each bar, actually they are the same number but in different formats, one is in numeric value and other is in percentage

       

      I was looking to use one of these expressions

       

      dual(Sum(FATURADO),Num(Sum(FATURADO) / Sum( TOTAL FATURADO), '#.##0,00%'))

       

      num(Sum(FATURADO),'#.##0,00')&' ('&Num(Sum(FATURADO) / Sum( TOTAL FATURADO), '#.##0,00%')&')'

       

      But this not worked how I was expecting

       

      Someone can help me on that?

       

      Thanks