Arbitrary Range Sum with Set Analysis (Easy YTD calc.)

[#1]

Hi QlikHeads!

How can you use a field value (e.g. week) instead of a fixed value in the Set Analysis expression for summing over an interval?

Pls. see enclosed example: Imagine that we have 5 weeks associated with values. When I select a week(or range) I want my set analysis to make a sum of all values from W0 -> max(week).

In the example it works with a fixed value (e.g. '4') but how can I use the Field "Week"?

Regards,

Lars Madsen

[#2 · Accepted solution]

Hi Lars,

here you go:

sum( {$<Week = {">=$(=Min(Week))<=$(=Max(Week))"}>} Value)

Good luck!

Rainer

[#3]

Hi Rainer

Thanks - it works beautifully!

I just love Set Analysis.

Lars

[#4]

Thanks of lot!... Really worked great!

I love set analysis too!