Was wondering if someone could assist with an expression for a table box.
I have a table box which I am using as a detailed transaction listing. I have 2 columns called counted and collected. I would like the table box to only return lines if either column counted or collected is greater than 0.
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?