topic Re: Accumalative Results on a complex Tab (Pivot) in QlikView

Accumalative Results on a complex Tab (Pivot)

Anonymous — Wed, 23 Sep 2015 13:48:45 GMT

Hi,

I have a problem to cumulate result on a tab.

Check screenshot and my application.

On the line L3 Y2D i want to sum the data of L3 :

In january : 6

In February : 6 + 2

In March : 6 + 2 + 2

In April 6 + 2 + 2 + 2

Thank you very much,

Regards!

Re: Accumalative Results on a complex Tab (Pivot)

Anonymous — Fri, 25 Sep 2015 06:53:04 GMT

Up!!

Re: Accumalative Results on a complex Tab (Pivot)

Tue, 29 Sep 2015 14:28:39 GMT

Hi Emilien,

Look at the file attached.

Your intuition was almost right, but in this case you want to accumulate Columns instead of Rows, so you have to use Before() function instead of Below.

Example :

RangeSum(Before(TOTAL sum(TARGET.TARGET_L3),0,ColumnNo(TOTAL)))

Regards,

Benoit

Re: Accumalative Results on a complex Tab (Pivot)

Anonymous — Tue, 29 Sep 2015 14:51:32 GMT

Merci Benoit ça correspond exactement à ce que j'attend.

Bonne journée!