topic Re: Help needed in identifying records in QlikView

Help needed in identifying records

Thu, 20 Nov 2014 22:43:44 GMT

I have three tables Players, Team, Plays

i want to know the Players who plays for same Teams. In my attached qvw PLayerID 2 and 3 plays for same Teams, Playerid1 also plays for the same teams but PlayerID 1 also plays for other teams.

So i want to know the Players who plays for same teams like PLayerID 2 and 3

Re: Help needed in identifying records

Thu, 20 Nov 2014 23:10:01 GMT

Hi,

I using a concat function to get a SameTeam identifier, for example Players 2 and 3 play in teams 1 and 3 so IdSameTeam is 13 and then to identify IdSameTeam with two players or more... use a list box and check "Show Frecuency" or use a pivot table with IdSameTeam, PlayerName as Dimension and if you want count(distinct playername) as expression.

See attached file.

Regards.

Re: Help needed in identifying records

Fri, 21 Nov 2014 02:35:33 GMT

Awesome Idea Thanks alot