Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
DKjewelry
Contributor
Contributor

Hide null expression rows by enabling conditional

I would like to show a list of names who are assigned to >2 teams.   My data is as follows:

DKjewelry_0-1647994322282.png

This is what I'd like my table to look like:

DKjewelry_2-1647994544927.png

I built a pivot table trying to work my way into the view above.  This is what I have so far:

DKjewelry_3-1647994630721.png

 

I used an expression to calculate the count of teams each person is assigned to:   

=count( distinct total <xName> xteam )

I used another expression to reflect only those names with >2 teams, setting the rest to null():  

=if( count( distinct total <xName> xteam)>2,xteam,null() )

Using this information, I was trying to work my way to hide the null rows with 1 or 2 teams, but couldn't figure out the right expression to use in the Conditional box.

 

Would greatly appreciate any ideas!  Thank you.  Attached is the sample .qvw file 

Labels (1)
1 Solution

Accepted Solutions
Marijn
Creator II
Creator II

Is it necessary to have multiple rows to show the different teams? You can use

=if(count(distinct Team)>2,concat(Team,', '))

to show the teams in one field. Looks like this:

Marijn_0-1648563162867.png

 

View solution in original post

2 Replies
Marijn
Creator II
Creator II

Is it necessary to have multiple rows to show the different teams? You can use

=if(count(distinct Team)>2,concat(Team,', '))

to show the teams in one field. Looks like this:

Marijn_0-1648563162867.png

 

DKjewelry
Contributor
Contributor
Author

Thank you @Marijn !  This worked great!