Discussion board where members can get started with QlikView.
What formula / expression do I use to make my text object show the max number and the equivalent subject / name?
Go to Solution.
It can be something like:
=Aggr(If(Rank(Count(ActivityName))=1, ActivityName & ': ' & Count(ActivityName)), ActivityName)
Hi Stephen, can you post an example of the data and which results are you expecting?
A simple text explanation will be enough
So I have quite a lot of activities and I want the text object to show the sum of the highest activity, along with the activity name only.
Does this explain?
Beautiful! Just beautiful