Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for 
Search instead for 
Did you mean: 
asisa_bi
Contributor III
Contributor III

Pivot table with aggregated columns

Hi

I want to create a Pivot Table where I will show Items sold and profit per year (row). In addition, I want to show a third metric column with the aggregated profit from first row until each row. For example, forth row (2014) will be the sum profit of 2011 + 2012 + 2013 + 2014.

qlikview.PNG

I'm trying to get it with Set Analisis, AGGR and TOTAL functions, without success. Please, anyone knows how can I get it?

Thanks in advance

Cheers

1 Solution

Accepted Solutions
sunny_talwar

May be try this

RangeSum(Above(Sum(Profit), 0, RowNo()))

View solution in original post

6 Replies
sunny_talwar

May be try this

RangeSum(Above(Sum(Profit), 0, RowNo()))

marcus_sommer
MVP & Luminary
MVP & Luminary

You need interrecord-functions for this tasks, for example:

rangesum(above(sum(Profit), 0, rowno(total)))

- Marcus

asisa_bi
Contributor III
Contributor III
Author

Thanks!!, it works but the partial sum (default row with total) is not calculated, is it normal?

asisa_bi
Contributor III
Contributor III
Author

Thanks Marcus!

sunny_talwar

You might be able to use Dimensionality() function to calculate a partial sum... but I am not sure what the partial sum needs to look like for accumulated value?

How to use - Dimensionality()

asisa_bi
Contributor III
Contributor III
Author

Thanks, I will check it