3 Replies Latest reply: Feb 20, 2014 11:14 AM by Nicole Smith RSS

    Getting the modal average of a column containing strings

      Let's say I have two tables like:

       

      Orders:

       

      Order IDUser ID
      ord11
      ord22
      ord31

       

      Users:

       

      User IDUser Name
      1Jordan
      2Clive

       

      I have somewhat like the tables above being brought into Qlikview.

       

      Is there a way, in a text object's expression, that I can print the user that has added an order the most amount of times (the Modal Average)? In the example above it would print Jordan, because he has added two orders where Clive has only added 1. This is of course a very simplified example, but it has the basic idea.