Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor III

Filter of entries in the table

Hello,

I would like to know your advice of solving my problem. I have a table which has a structure as showed below:

Header 1Header 2Header 3
MatchIDHomeTeamNameVisitorTeamName

And I have separate table which has all team names. So I need to filter my table by Team name which can be in the field HomeTeamName OR VisitorTeamName


Do you have any ideas how to solve it?


Thanks,

1 Solution

Accepted Solutions
Highlighted
Valued Contributor

Re: Filter of entries in the table

Add a column =Count({<HomeTeamName=P(TeamName)>}HomeTeamName) + Count({<VisitorTeamName=P(TeamName)>}VisitorTeamName)

Suppress zeros on the column and you can hide the column.

View solution in original post

4 Replies
Highlighted
Valued Contributor

Re: Filter of entries in the table

Add a column =Count({<HomeTeamName=P(TeamName)>}HomeTeamName) + Count({<VisitorTeamName=P(TeamName)>}VisitorTeamName)

Suppress zeros on the column and you can hide the column.

View solution in original post

Highlighted
New Contributor II

Re: Filter of entries in the table

if it just to show such matches in a chart table - can be achieved through expressions like below.

Dimension - MatchID

Expression1 = "MaxString({$<MatchID={"=if(HomeTeamName=TeamName OR VisitorTeamName=TeamName,1,0)=1"}>}HomeTeamName)

Expression2 = "MaxString({$<MatchID={"=if(HomeTeamName=TeamName OR VisitorTeamName=TeamName,1,0)=1"}>}VisitorTeamName)

Highlighted
New Contributor III

Re: Filter of entries in the table

Thank you, but my question was solved in a previous answer

Highlighted
New Contributor III

Re: Filter of entries in the table

Thank you. I don't understand how it works, but it works and I'll try to understand proposed solution later!