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

Announcements
ALERT: QlikView server communication interruptions following Microsoft Windows Domain Controller security updates
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