Getting the modal average of a column containing strings
Let's say I have two tables like:
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.