5 Replies Latest reply: Aug 3, 2017 7:56 AM by Tal Sibony RSS

    Function to find the most common value per dimension (qlik sense)

    Tal Sibony

      hi,

       

      let's say for instance we have the data set below (loaded to Qlik):

       

      dimensionvalue
      a2
      b1
      c2
      a5
      c2
      b3
      a4
      a2
      c2
      c3
      b3

       

      i would like to create a chart and receive the output as following:

        

      dimensionmost common value
      a2
      b3
      c2

       

      is there a function or a technique to receive such a result?

       

      tnx,

      Tal