topic Re: Exclude Zero value on an expression in QlikView

Exclude Zero value on an expression

Fri, 17 Apr 2015 15:34:52 GMT

Hi,

how to exclude Zero value on an Expression?

Anonymous — Fri, 17 Apr 2015 15:44:11 GMT

You didn't tell what expression. for the generic question, I can give a generic answer:

<an aggregation function> ({<Value-={0}>} Value)

Fri, 17 Apr 2015 15:46:02 GMT

Hi,

below is my expression

if(Count(CustomerCodeName)>0,sum(aggr(count(DISTINCT SalesmanDate),CustomerCodeName,SalesmanDate)))

Anonymous — Fri, 17 Apr 2015 15:53:11 GMT

This is better

Try this, it will work unless I miscounted the parenthesis:

sum(if(

aggr(count(DISTINCT SalesmanDate),CustomerCodeName,SalesmanDate)>0,

aggr(count(DISTINCT SalesmanDate),CustomerCodeName,SalesmanDate)

))