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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?