Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

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

Re: Expression syntax

Hi herbert

so tick   "suppress 0 value" in presentation tab

or use Dimension Limit tab to set your limit

best regards

Chris

MVP
MVP

Re: Expression syntax

in table box you can only flag

"Omit Rows Where Fields is NULL"

in "Presentation" tab

Not applicable

Re: Expression syntax

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

Re: Expression syntax

Hi Herbert,

you can add a condition on Dimension Limit Tab:

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

MVP
MVP

Re: Expression syntax

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

Community Browser