topic Re: expression containing 1- or -1 in QlikView

expression containing 1- or -1

surajap123 — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Just wondering what is -1 or 1- indicate when we do division in the expression.

eg-

1- Sum(Cost)/sum(Sales)

column(1)/ column (2) -1

So, in above expressions what is the significance of 1- in first expression and -1 in the second expression?

Thanks

swuehl — Sun, 21 Aug 2016 12:38:30 GMT

Division precedes the subtraction, so it's basically

1 - DivisionResult

vs.

DivisionResult -1

Hence both expressions differ in sign.

surajap123 — Sun, 21 Aug 2016 13:59:24 GMT

Thanks Stefan.

Could you tell me why the business want to substract. I mean what is the general use case.

swuehl — Sun, 21 Aug 2016 14:05:18 GMT

For example

1- Sum(Cost)/sum(Sales)

equals

( Sum(Sales) - Sum(Cost) )

Sum(Sales)

which could be read as profit percentage (in relation to sales)

surajap123 — Sun, 21 Aug 2016 14:42:32 GMT

Thanks