Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Ytd values using AGGR()?

Hi!

I have a pivot table and would like to show one column with the 'Price' per 'Period' and one column with YTD sum of 'Price' ie ackumulated sum per period.

 

Can someone help me work out how to achive the desired YTD columns?

YTD data.JPG

Thanks,

Labels (3)
1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

I solved it using range instead 🙂

RangeSum(Before(Sum([Price (SEK)]), 0, ColumnNo()))

View solution in original post

1 Reply
Highlighted
Contributor III
Contributor III

I solved it using range instead 🙂

RangeSum(Before(Sum([Price (SEK)]), 0, ColumnNo()))

View solution in original post