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

How to show accumulated values in text object box?

I understand that accumulated data points can be shown in the chart by setting it in the 'expression' tab. But i have diffculty showing the figures in text object box. Anyone care to advise on how to calcuate the accumulated data??

Example:

Actual Data: Jan=206, Feb=225, Mar=299

Accumlated data: Jan=206, Feb=431, Mar=730 ( this is the final figure i wanted to show in the text object box)

Would appreciate your help in this! 😃

2 Replies
amars
Specialist
Specialist

As there is nothing like Full Accumulation for Text boxes & ur months are also fixed u can write individual 12 formulas for 12 month text boxes

like Jan Text box = Sum(Jan Sales) Feb textbox* = (Jan Sales+ Feb Sales)

riceball
Contributor
Contributor
Author

Thanks for your suggestion. In this case, is it possible to show only one textbox just for that particular month?