topic Re: Expression syntax in QlikView

Expression syntax

Wed, 12 Mar 2014 14:12:33 GMT

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

Re: Expression syntax

Wed, 12 Mar 2014 14:15:10 GMT

Hi herbert

so tick "suppress 0 value" in presentation tab

or use Dimension Limit tab to set your limit

best regards

Chris

Re: Expression syntax

maxgro — Wed, 12 Mar 2014 14:22:02 GMT

in table box you can only flag

"Omit Rows Where Fields is NULL"

in "Presentation" tab

Re: Expression syntax

Wed, 12 Mar 2014 14:42:41 GMT

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

Re: Expression syntax

Wed, 12 Mar 2014 14:54:47 GMT

Hi Herbert,

you can add a condition on Dimension Limit Tab:

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

Re: Expression syntax

maxgro — Wed, 12 Mar 2014 14:59:40 GMT

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