topic Re: Expression returning -0 in QlikView

Expression returning -0

qlikmpate0 — Fri, 23 Mar 2018 10:19:38 GMT

I have the following expression

(sum(alt(AMOUNT_DUE_REMAINING,0))-Sum(Alt(AMOUNT_APPLIED,0)))/1000

33
0
60
10,571
23
86
512
2,827
1,339

but if I change it to

sum(alt(AMOUNT_DUE_REMAINING,0))-Sum(Alt(AMOUNT_APPLIED,0))/1000

I get these figures which are great because the zero figure on the second row is correct, although the rounding is missing on all figures. I have tried the round function but still the same values.

32,526
-117
59,925
10,571,403
22,975
85,759
512,471
2,827,071
1,338,635

Thanks much appreciated in advance.

Re: Expression returning -0

MK_QSL — Fri, 23 Mar 2018 10:23:26 GMT

Provide sample data to check..

Re: Expression returning -0

sasiparupudi1 — Fri, 23 Mar 2018 10:32:33 GMT

Both of your expressions look same?

Re: Expression returning -0

qlikmpate0 — Fri, 23 Mar 2018 10:57:32 GMT

The brackets are in different places

(sum(alt(AMOUNT_DUE_REMAINING,0))-Sum(Alt(AMOUNT_APPLIED,0)))/1000

sum(alt(AMOUNT_DUE_REMAINING,0))-Sum(Alt(AMOUNT_APPLIED,0))/1000

Re: Expression returning -0

qlikmpate0 — Fri, 23 Mar 2018 11:03:03 GMT

the data is part of a complex model and I cannot due to company policy also not too sure how to extract correctly for you to check.

Re: Expression returning -0

sasiparupudi1 — Fri, 23 Mar 2018 11:20:28 GMT

What is the expected output? the second table?

Re: Expression returning -0

sunny_talwar — Fri, 23 Mar 2018 11:25:21 GMT

I think in your first expression you are dividing the subtraction of two expression by a 1000

(Expression1 - Expression2)/1000

and in expression 2, you are dividing just the expression2 by 100

Expression - (Expression/1000)

Now, I am not sure what you are trying to do... do you mind explaining what the goal is?

Re: Expression returning -0

qlikmpate0 — Fri, 23 Mar 2018 11:40:59 GMT

the goal is to have the output like this

33
-117
60
10,571
23
86
512
2,827
1,339

Re: Expression returning -0

MK_QSL — Fri, 23 Mar 2018 11:45:19 GMT

LOL... without knowing your data, how we can give you same output..???

Re: Expression returning -0

sunny_talwar — Fri, 23 Mar 2018 11:46:31 GMT

Try this may be

If(

(Sum(AMOUNT_DUE_REMAINING) - Sum(AMOUNT_APPLIED))/1000 = 0,

-Sum(AMOUNT_APPLIED)/1000,

(Sum(AMOUNT_DUE_REMAINING) - Sum(AMOUNT_APPLIED))/1000

)

Re: Expression returning -0

sasiparupudi1 — Fri, 23 Mar 2018 12:07:34 GMT

Re you using the expression in a straight table? what is the number formatting used on this expression? may be its just a display issue