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



      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?