Limiting the number of columns in Pivot table

[wttaryde]

We have a problem with our pivot tables, because we can’t make the columns narrow enough to put all 40 companies side-by-side on one chart.  Neither Qlik nor VizLib gives us the control we need for that.  So we have a workaround…

We’ve limited our dimension (YearID) for columns using this expression

=if(match(YearID,'10','11','12','13','14','15','16','17','18','19','20','21','22','23','24'), YearID,’99‘)

This particular expression causes an extra column on the end of the table where all of the other YearID numbers are grouped.  This expression has '99' as the column header, but we’ve done it with that column header being blank. 

I’m trying to figure out how to modify the expression to “only" show the columns for the YearIDs that match and ignore the YearIDs that don't match.

[MikeW · Accepted solution]

You can use Null() instead of '99' and set the dimension to hide nulls

[wttaryde]

Such a simple answer.  Thanks.