Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to do a rolling value

I have some values which are separate for each of the months. However I would like it to be displayed in a rolling total so January would simply have January's figure in but February would have their value in as well as January's.

Month
Value

Expected

Value

Jan22
Feb35
Mar27
April18
1 Solution

Accepted Solutions
CELAMBARASAN
Partner - Champion
Partner - Champion

Use Month as Dimension.

Expression Label: ValueExp

Expression : Alt(Above([ValueExp]),0) +Sum(Value)

Or

Use Fully Accumulated option in the Expression tab under Accumulation section.

Hope it helps

View solution in original post

2 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Use Month as Dimension.

Expression Label: ValueExp

Expression : Alt(Above([ValueExp]),0) +Sum(Value)

Or

Use Fully Accumulated option in the Expression tab under Accumulation section.

Hope it helps

Not applicable
Author

yeah.

Good answer........

Regards,

Kabilan K