topic Re: Cum. periods in QlikView

Cum. periods

Mon, 06 Jul 2015 13:45:40 GMT

When I do this formula:

=sum({<YEAR={"$(=MAX(YEAR))"}>}{<PERIOD={"$(=MAX(PERIOD))"}>}
(
If(REKENING>= 8000,
If(REKENING<= 8499,
(([KREDIT])/100)-(([DEBET])/100)
,0)))
-
If(REKENING= 8405,
(([KREDIT])/100)-(([DEBET])/100)
,0))

I get the answer about for the max year and the max period.

But I want to have a cumulative with all periods.

When I select period 4. I want the answer about period 1, 2, 3, and 4. With this formula I only get about period 4.

How can I do that?

Re: Cum. periods

MK_QSL — Mon, 06 Jul 2015 13:47:37 GMT

May be

=RangeSum(Above(sum({<YEAR={"$(=MAX(YEAR))"}>}{<PERIOD={"$(=MAX(PERIOD))"}>}

(

If(REKENING>= 8000,

If(REKENING<= 8499,

(([KREDIT])/100)-(([DEBET])/100)

,0)))

If(REKENING= 8405,

(([KREDIT])/100)-(([DEBET])/100)

,0)),0,RowNo()))

Re: Cum. periods

sunny_talwar — Mon, 06 Jul 2015 13:50:39 GMT

Try what Manish‌ just gave you, but in case it doesn't work, I suggest providing a sample and its expected output which would help us understand your requirement better.

Best,

Sunny