topic can any one tell me difference between aggregation and range sum? in QlikView

can any one tell me difference between aggregation and range sum?

Fri, 10 Oct 2014 12:43:44 GMT

plz any one share the answer..........

Re: can any one tell me difference between aggregation and range sum?

alexandros17 — Fri, 10 Oct 2014 12:47:35 GMT

Range sum return the sum of more values, it is useful because automatically discard null or strings so:

Rangesum(1,4,null(), 'ANC') returns 5

Aggr function is a completely different function, it aggregates more values with the same value

Re: can any one tell me difference between aggregation and range sum?

Fri, 10 Oct 2014 12:48:58 GMT

Aggregation is used to aggregate values across different dimensions.

Eg: Aggr(Sum(Sales),Month,Country)

Sales is aggregated at Month and Country level.

RangeSum is used to calculate sum of range of values.

Eg: Rangesum(1,5,10) gives 1+5+10=16

Rangesum(Above(Sum(Sales),0,5) returns sum(Sales) of above 5 rows from the current row.

Re: can any one tell me difference between aggregation and range sum?

maternmi — Fri, 10 Oct 2014 12:51:43 GMT

Hi,

rangesum:

Returns the sum of a range of 1 to N arguments. As opposed to the + operator, rangesum will treat all non-numeric values as 0.

aggregation sum:

Returns the sum of expression over a number of records as defined by a group by clause. If the word distnict
occurs before the expression, all duplicates will be disregarded.

hope that helps you.