Hide null expression rows by enabling conditional

DKjewelry — Wed, 23 Mar 2022 00:18:07 GMT

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

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

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

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

Re: Hide null expression rows by enabling conditional

Marijn — Tue, 29 Mar 2022 14:13:26 GMT

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:

Re: Hide null expression rows by enabling conditional

DKjewelry — Fri, 01 Apr 2022 17:44:09 GMT

Thank you @Marijn ! This worked great!

topic Re: Hide null expression rows by enabling conditional in QlikView

Hide null expression rows by enabling conditional

Re: Hide null expression rows by enabling conditional

Re: Hide null expression rows by enabling conditional