how to remove Null values in Expression level

[abubakarsiddiq7]

Hi Experts,

Need help on removal of null values in Expression level 

for example i have around 15000 records and i have applied some condition ,records got reduced to 800 .

now i want to show only those 800 records in straight table in qlikview .

 Expression :

if(num(aggr(sum({<Month = {'<=$(=Max(Month))'}, AGNTMTD={1}>}Life_ANP_YTD),AGNT_ID), ' #,##0')>=(5000000/12)*num(Max(Month)),'VIP',0)

just wanted to sow only VIP Records .

[BrunPierre]

How about suppressing when the value is null under the dimension tab?