Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

homersimpson
Contributor II

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

Re: Sum up the worth of dimension

Use this expression may be:

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


Capture.PNG

homersimpson
Contributor II

Re: Sum up the worth of dimension

Hi,

thank you. Is there another easy way without formulas?

Best regards

Homer

Re: Sum up the worth of dimension

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.

Community Browser