How to Calculate

alvinford — Tue, 01 Mar 2011 08:54:16 GMT

Hi I have the following issue

I am calculating the G% value as (TY-LY) / LY using the below data.NO issues in calculating the G%

I want to Calculate the P% using the cummulative values Row wise i.e

In the above example I have calculated manually . How can I achieve this in QlikView.

Thanks in Advance,

Regards,

Alvin.

deepakk — Tue, 01 Mar 2011 10:03:29 GMT

hi,

I hope attach application helps you out.

alvinford — Wed, 02 Mar 2011 02:28:13 GMT

Thanks Deepak,

Regards,

Alvin.

Wed, 02 Mar 2011 03:37:59 GMT

Hi,

one of solutions, P%;

(RangeSum(above(sum(TY),0,NoOfRows()))-RangeSum(above(sum(LY),0,NoOfRows())))
/RangeSum(above(sum(LY),0,NoOfRows()))

regards,

kaz

topic How to Calculate in QlikView