Using RangeSum values conditionally

[#1]

I'm new to Qlikview and need some help figuring out on how to use RangeSum functionality. I was able to create cumulative values across a pivot table using the following formula -

=RangeSum(Alt(Before([Amount Acc]), 0), Sum([Amount]))

Amount is the column being accumulated and Amount Acc is my expression on the pivot table.

I have a requirement to conditionally show the accumulated values in the pivot table based on a range of values of that a user will input. For this I've created two variables vMax and vMin. Is there anyway I can limit the accumulated values to between these 2 variables?

Any help will be appreciated!

[marcus_sommer]

You could use an if-loop or set analysis within your rangesum, maybe like this:

sum({<date = {">=$(vMin)<=$(vMax)"}>} Amount)

- Marcus