Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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!