Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
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.
Thank you
Herbert
Hi herbert
so tick "suppress 0 value" in presentation tab
or use Dimension Limit tab to set your limit
best regards
Chris
in table box you can only flag
"Omit Rows Where Fields is NULL"
in "Presentation" tab
Thanks Massimo,
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?
Thanks
Herbert
Hi Herbert,
you can add a condition on Dimension Limit Tab:
Show only values that are 'Greater than 0 Exact Amount'
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
load
counter,
collected,
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