Aggregation functions for Count and Sum

its_anandrjs — Thu, 11 Aug 2011 13:07:19 GMT

Hi All,

Any one provide details about the Aggr function for count and sum and more with details. Help will be appreciated

Regards,

Anand

Re: Aggregation functions for Count and Sum

johnw — Fri, 12 Aug 2011 00:12:26 GMT

What sort of details? Here's the help text if you haven't read it. I'm not sure what else I can provide.

sum( [{set_expression}] [ distinct ] [ total [<fld {, fld}>] ] expression )

Returns the aggregated sum of expression or field iterated over the chart dimension(s).

Examples:

sum( Sales )
sum( Price*Quantity )
sum( distinct Price )
sum( Sales ) / sum( total Sales )	returns sales within the selection.
sum( Sales ) / sum( total <Month> Sales )	returns sales within the selection for each Month
sum( Sales ) / sum( total <Month,Grp> Sales )	returns sales within the selection for each Month and Grp
sum( Sales ) / sum( {1} totalSales )	returns sales within the entire document.
sum( {BM01} Sales )	returns sales within the selection defined by bookmark BM01.
sum({$<Year={2007,2008}>}Sales)	returns the sales for the current selection but just for year 2007 and 2008, i.e. the same as Sum(if(Year=2007 or Year=2008,Sales))

count( [{set_expression}] [ distinct ] [ total [<fld {, fld}>] ]expression)

Returns the aggregated total count of values from expression or field iterated over the chart dimension(s).

For this function it is allowed to use the distinct qualifier in combination with the total qualifier This combination is not valid for any other aggregation functions.

Examples:

count( Sales )
count( Price*Quantity )
count( distinct Price )
Count( Alpha ) / Count ( Distinct Total Alpha)
count( Sales ) / count( total Sales )	returns sales within selection.

Re: Aggregation functions for Count and Sum

Fri, 30 Oct 2015 11:59:59 GMT

Thanks John, This is really Helpful

This solved my issue

topic Re: Aggregation functions for Count and Sum in QlikView

Aggregation functions for Count and Sum

Re: Aggregation functions for Count and Sum

sum( [{set_expression}] [ distinct ] [ total [<fld {, fld}>] ] expression )

Examples:

count( [{set_expression}] [ distinct ] [ total [<fld {, fld}>] ]expression)

Examples:

Re: Aggregation functions for Count and Sum