Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

emilienp
New Contributor III

Accumalative Results on a complex Tab (Pivot)

Hi,

I have a problem to cumulate result on a tab.

Check screenshot and my application.

2015-09-23 15_39_10-QlikView x64 - [C__Users_epetrini_Desktop_HELP.qvw].png

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

2015-09-23 15_44_02-Microsoft Excel - CH84_20150923_154040.xls  [Mode de compatibilité].png

Thank you very much,

Regards!

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Accumalative Results on a complex Tab (Pivot)

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

3 Replies
emilienp
New Contributor III

Re: Accumalative Results on a complex Tab (Pivot)

Up!!

Not applicable

Re: Accumalative Results on a complex Tab (Pivot)

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

emilienp
New Contributor III

Re: Accumalative Results on a complex Tab (Pivot)

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

Bonne journée!