topic Rangesum all values small than in QlikView

Rangesum all values small than

Wed, 25 Nov 2020 16:16:04 GMT

I only know how to sum up values for one column using something like:

sum({<AMOUNT = {"<99"}>} AMOUNT)

What is the expression to rangesum columns only summing up values smaller than 99?

rangesum(data1, data2, data3, data4)

Thu, 26 May 2016 08:17:51 GMT

Mhh right now I get back a 99.

To verify, can I somehow do set analysis like for year in that?

jonathandienst — Thu, 26 May 2016 08:19:20 GMT

RangeSum is not a set aggregator, so you cannot use set expressions. You will need to use If or RangeMin expressions:

RangeSum(If(A < 99, A), If(B < 99, B))

RangeSum(RangeMin(A, 99), RangeMin(B, 99))

tamilarasu — Thu, 26 May 2016 08:47:29 GMT

At first glance, I misunderstood the question. You can use Jonathan's solution.

RangeSum(RangeMin(A, 99), RangeMin(B, 99), RangeMin(C, 99), RangeMin(D, 99))