topic Re: Expression in straight table not working? in QlikView

Expression in straight table not working?

Fri, 12 Jun 2015 11:27:12 GMT

HI,

I have straight table in qvw as below

Dimension : REGION

Expr 1 : SALES

Expr 2 : GOODS

Expr 3 : OTHERS

Expr 4 : NOTSOLD

when I am trying to calculate Overall Total =

Column (1)+Column (2)+Column (3)-(Column (4))

it is showing blank values. Is there any wrong in expression?

please can anyone suggest me.

Thanks.

swuehl — Fri, 12 Jun 2015 11:29:59 GMT

OTHERS lines are NULL?

Then you need rangesum() to add up (or better, use rangesum() anyway):

=Rangesum(column(1),column(2),column(3), -column(4) )

robert_mika — Fri, 12 Jun 2015 11:30:55 GMT

Maybe:

SALES+GOODS +OTHERS-NOTSOLD

Fri, 12 Jun 2015 11:32:58 GMT

Thanks. That's right

Fri, 12 Jun 2015 11:33:04 GMT

Thanks.