Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Help needed in identifying records

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

1 Solution

Accepted Solutions
Not applicable

Re: Help needed in identifying records

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.

2 Replies
Not applicable

Re: Help needed in identifying records

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.

Not applicable

Re: Help needed in identifying records

Awesome Idea Thanks alot

Community Browser