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 .
