topic Re: Trouble with calculated dimension ignoring current selection in QlikView

Trouble with calculated dimension ignoring current selection

Anonymous — Tue, 15 Dec 2015 11:55:02 GMT

Hi everybody:

I'm trying to make calculated dimension ignoring part of the restriction of current selections.

I have data about a test. There are three teams that have passed the test. I have the name of the team members, the score they got in the test and the team they belong to.

I want to compare myself with the rest, so when I select a team in the team selector I want to compare the members of the team with me.

I have tried to make a calculated dimension in this way:

=Aggr(only({<Team={"*"}>+1<Name={'Me'}>}Name), Name)

but it doesn't work.

Can anybody help me?

Re: Trouble with calculated dimension ignoring current selection

sunny_talwar — Tue, 15 Dec 2015 12:05:50 GMT

Please don't create duplicate threads -> Trouble with calculated dimension ignoring selections

Re: Trouble with calculated dimension ignoring current selection

Anonymous — Tue, 15 Dec 2015 12:31:13 GMT

Sorry

Re: Trouble with calculated dimension ignoring current selection

sunny_talwar — Tue, 15 Dec 2015 12:41:47 GMT

No worries

Re: Trouble with calculated dimension ignoring current selection

paolocamerini — Tue, 15 Dec 2015 13:18:40 GMT

Hello!

Let's make things simpler.

See the attached .qvw

Moved the Only function into expressions. Put a persistent column pointing out "me" score and tweaked the graph a little to make it look better.

Obviously it can be done a lot better but it gets to the point!