1 Reply Latest reply: Sep 19, 2016 11:43 AM by Shahbaz Khan Mohammed RSS

    Dynamically Convert Number to percentage in qlik sense

    Dhanalakshmi Vairaperumal

      is there a way of dynamically changing a format of a bar chart depending on its values....


      some rows of data are for percentages



      1)Attaintment in  75%


      2)Sales in  1008   number value


      when user select Attainment bar should be in % when user selects sales it should be number


      i tried using the option


      =NUM( (sum(sales)/Sum(target))*100, '##.##%','.',',')

      also tried

      =NUM( (sum(sales)/Sum(target)), '##,00%',',','.')


      = values &'%'

      same expression in working in text box but not working in line chart. i have set the formatting to 'AUTO'.

      Please suggest an option to fix the issue