Set analysis {1} doesn't seem to work

[#1]

Hi, I need the text boxes on the right side not to get affected because of selections. I tried using {1} but doesn't seem to help.

Files attached. Kindly help.

Thanks

Ram

[#2]

You'd need the aggregations to ignore selections also:

=firstsortedvalue({1}Runs, aggr(min({1<Fifties={">0"}>} Runs), Player))

[#3]

Thanks very much. Everything works fine now except a list box that I have with the following expression.

=aggr(if(rank(sum(Runs))<=10,Player),Player)

[#4 · Accepted solution]

Are you trying to make a non-interactive list box of the top 10 players?

I'm not sure you can make a dimension ignore itself through set analysis.  Since the list box is a list aggregated by Player, I don't think it can ignore the Player selection.  You're saying "For each possible player, show me the player that satisfies the 'if' condition."

You could place the list box in an alternate state so that it is not affected by other selections on the document if you are using Qlikview 11.

(Settings ~> General ~>  Alternate States ~>  Add, List box properties ~> Alternate State select the new one)

[#5]

Alternate States fits the bill perfectly. Thanks very much. One last thing I wanted to was to make the List box read only as well which I have done now.