topic Re: 1,730,509 / 4,884,817 = 0.354 But QV Return 5.01 in QlikView

1,730,509 / 4,884,817 = 0.354 But QV Return 5.01

paulyeo11 — Fri, 25 Dec 2015 11:28:41 GMT

Hi All

I have a QV Doc

it return wrong cal value.

Hope some one can advise me where i go wrong ?

Paul

Re: 1,730,509 / 4,884,817 = 0.354 But QV Return 5.01

sunny_talwar — Fri, 25 Dec 2015 12:04:17 GMT

For your COGS_INT expression, you were using Full Accumulation method, but unfortunately when you use Column(1)/Column(2), it doesn't take the accumulated values, but the original un-accumulated values. A work around is to use no accumulation with RangeSum(Above()) expression:

If(sum(STK_CLOSE) > 0 and sum(STK_OPEN) > 0, RangeSum(Above(Sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} (COGS+COGS_INT_)/1), 0, RowNo())))

Once you that the Column(1)/Column(2) calculation is fixed.

Re: 1,730,509 / 4,884,817 = 0.354 But QV Return 5.01

paulyeo11 — Fri, 25 Dec 2015 12:20:12 GMT

Hi Sunny

Thank you very much for your help.

Paul

Re: 1,730,509 / 4,884,817 = 0.354 But QV Return 5.01

sunny_talwar — Fri, 25 Dec 2015 12:21:32 GMT

Not a problem. I am glad I have been helpful

Re: 1,730,509 / 4,884,817 = 0.354 But QV Return 5.01

paulyeo11 — Fri, 25 Dec 2015 13:00:16 GMT

Hi Sunny

I have another question related to compute the result i need :-

Expression for create each row 30 count total 12 row 360 count ?