Skip to main content
Announcements
Live today at 11 AM ET. Get your questions about Qlik Connect answered, or just listen in. SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Sum up the worth of dimension

Hi,

see attachment, please.

I want to show the sum up from the month on the x axis.

Example:

MonatSonnentage
Januar4
Februar3
März8
April9

In the graph i want to show this:

Januar = 4 | Februar = 7 | März = 15 | April = 24

How can i do that?

I don´t want to show:

Januar = 4 | Februar = 3 | März = 8 | April = 9


Best regards

Homer

3 Replies
sunny_talwar

Use this expression may be:

RangeSum(Above(Sum(Sonnentage), 0, RowNo()))


Capture.PNG

Anonymous
Not applicable
Author

Hi,

thank you. Is there another easy way without formulas?

Best regards

Homer

sunny_talwar

If this is in the straight table, then yes there is another way using Full Accumulation. But if its any other chart like a bar chart or line chart. Then no, this is the only way (in addition to doing this in the script)

Update: Just realized that this is sense. I think the RangeSum(Above()) is the only way to do this in sense. A sense expert may be able to give you a better response.