Using RangeSum values conditionally

Mon, 22 Sep 2014 16:28:54 GMT

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!

Re: Using RangeSum values conditionally

marcus_sommer — Tue, 23 Sep 2014 09:10:50 GMT

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

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

- Marcus

topic Re: Using RangeSum values conditionally in QlikView

Using RangeSum values conditionally

Re: Using RangeSum values conditionally