Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Expression syntax

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

5 Replies
Not applicable
Author

Hi herbert

so tick   "suppress 0 value" in presentation tab

or use Dimension Limit tab to set your limit

best regards

Chris

maxgro
MVP
MVP

in table box you can only flag

"Omit Rows Where Fields is NULL"

in "Presentation" tab

Not applicable
Author

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

Not applicable
Author

Hi Herbert,

you can add a condition on Dimension Limit Tab:

Show only values that are 'Greater than  0    Exact Amount'

maxgro
MVP
MVP

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