Slight complication though, both columns have to have zero in them for the row to be ommited. The method you have suggested looks at one column at a time, whereas I need the decision to be based on both columns, kinda like an AND statement in Excel. Is there also a difference between NULL and Zero in QlikView?
in table box I think there isn't way to AND 2 omit rows and in tbale box you can't add espression
so if you want to stay with table box you should add a calculated field in the script
if(len(trim(counte))r=0 and len(trim(collected))r=0, null(), 1) as flag
and then omit flag when is null
I checked for null but you can adjust to your req
In a chart (a straight table, not table box) you have more choice