Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
FLASH SALE: Save $500! Use code FLASH2026 at checkout until Feb 14th at 11:59PM ET. Register Now!
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
Labels (1)
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