Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
knightwriter
Contributor III

Text object properties - max number and name

Hi All,

What formula / expression do I use to make my text object show the max number and the equivalent subject / name?

Many thanks.

Tags (2)
1 Solution

Accepted Solutions

Re: Text object properties - max number and name

It can be something like:

=Aggr(If(Rank(Count(ActivityName))=1, ActivityName & ': ' & Count(ActivityName)), ActivityName)

4 Replies

Re: Text object properties - max number and name

Hi Stephen, can you post an example of the data and which results are you expecting?

A simple text explanation will be enough

knightwriter
Contributor III

Re: Text object properties - max number and name

Hi Ruben,

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?

Re: Text object properties - max number and name

It can be something like:

=Aggr(If(Rank(Count(ActivityName))=1, ActivityName & ': ' & Count(ActivityName)), ActivityName)

knightwriter
Contributor III

Re: Text object properties - max number and name

Beautiful! Just beautiful