1 Reply Latest reply: Sep 19, 2016 11:43 AM by Aehman K 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

       

      KPI=

      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%',',','.')

      or

      = 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