3 Replies Latest reply: Mar 23, 2017 3:44 PM by Marco Wedel RSS

    Qlik sense, how to categorize a field into percentage

    Haikuo Yu

      How to categorize a field into percentage in Qlik sense load data editor?

      The column is my_value:

       

      try to use:

       

      load

      (my_value - min(my_value))/(max(my_value)-min(my_value)) as value_category

       

       

      and then use:

       

      if (value_category> 0.5, 'A',

      if(value_category>0.3, 'B', 'C'

      ))

       

      However, the first part does not work. Any suggestion is appreciated!