Set analysis {1} doesn't seem to work

[#1]

Hi, I have a few text boxes on the right in my qvw. I want them to stay put regardless of the change. I tried using {1} in all the expressions but that doesn't seem to help. For example the Top scorer is 'Shane Watson' and i want this to stay regardless and all the items on the right side should be have that way. Please help.

Sorry I am new to qlikview apologies if the question is trivial.

thanks

Ram

[Miguel_Angel_Baeyens · Accepted solution]

Hello Ram,

Not so trivial, actually:

=FirstSortedValue({1} TOTAL <Player> Player, -Aggr(Max({1} Runs), Player))

Note that I'm using TOTAL along with the "{1}", and that the "{1}" as set is used in the Max() function as well.

Hope that helps.

Miguel