topic Re: Set analysis {1} doesn't seem to work in QlikView

Set analysis {1} doesn't seem to work

Tue, 09 Oct 2012 13:45:32 GMT

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

Re: Set analysis {1} doesn't seem to work

Tue, 09 Oct 2012 13:55:15 GMT

You'd need the aggregations to ignore selections also:

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

Re: Set analysis {1} doesn't seem to work

Tue, 09 Oct 2012 14:02:44 GMT

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)

Re: Set analysis {1} doesn't seem to work

Tue, 09 Oct 2012 14:41:50 GMT

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)

Re: Set analysis {1} doesn't seem to work

Wed, 10 Oct 2012 03:29:47 GMT

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.