Limit pivot table to specific conditions

[#1]

Hey there - I'm loving Qlik. Every day I'm in it using new expressions to make my life easier! Here's a challenge I have.

The below pivot table contains 6 rows of data where there is a different models on each row.

I have another field called BTS which is either Yes or No. The values in the table are just average pricing.

My challenge is -- what do I need to do (can you please be specific) in order to get this table so that ONLY models are shown when the No and Yes contain a value?

[#2]

‌one option is to use set analysis and use the length  - lent() function to see if the credulity is greater than 0

see thread below for further detailed information

Blank or NULL in Set Analysis