Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Skip the ticket, Chat with Qlik Support instead for instant assistance.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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!

1 Solution

Accepted Solutions
Not applicable
Author

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

View solution in original post

3 Replies
Anonymous
Not applicable
Author

Up!!

Not applicable
Author

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

Anonymous
Not applicable
Author

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

Bonne journée!