topic Re: Aggregate function in QlikView https://community.qlik.com/t5/QlikView/Aggregate-function/m-p/848598#M1002315 <HTML><HEAD></HEAD><BODY><P><STRONG>Aggregation functions</STRONG> are function that accumulate values from multiple rows (like SUM, MIN.MAX)</P><P></P><P>Full list of Aggregation functions in Qlikview is quite large</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="108"><TBODY><TR><TD height="20" width="108">Avg</TD></TR><TR><TD height="20">Concat</TD></TR><TR><TD height="20">Correl</TD></TR><TR><TD height="20">Count</TD></TR><TR><TD height="20">FirstSortedValue</TD></TR><TR><TD height="20">Fractile</TD></TR><TR><TD height="20">InputAvg</TD></TR><TR><TD height="20">InputSum</TD></TR><TR><TD height="20">Kurtosis</TD></TR><TR><TD height="20">LastValue</TD></TR><TR><TD height="20">LINEST_B</TD></TR><TR><TD height="20">LINEST_DF</TD></TR><TR><TD height="20">LINEST_F</TD></TR><TR><TD height="20">LINEST_M</TD></TR><TR><TD height="20">LINEST_R2</TD></TR><TR><TD height="20">LINEST_SEB</TD></TR><TR><TD height="20">LINEST_SEM</TD></TR><TR><TD height="20">LINEST_SEY</TD></TR><TR><TD height="20">LINEST_SSREG</TD></TR><TR><TD height="20">LINEST_SSRESID</TD></TR><TR><TD height="20">Max</TD></TR><TR><TD height="20">MaxString</TD></TR><TR><TD height="20">Median</TD></TR><TR><TD height="20">Min</TD></TR><TR><TD height="20">MinString</TD></TR><TR><TD height="20">MissingCount</TD></TR><TR><TD height="20">Mode</TD></TR><TR><TD height="20">NullCount</TD></TR><TR><TD height="20">NumericCount</TD></TR><TR><TD height="20">Only</TD></TR><TR><TD height="20">Skew</TD></TR><TR><TD height="20">Stdev</TD></TR><TR><TD height="20">Sterr</TD></TR><TR><TD height="20">STEYX</TD></TR><TR><TD height="20">Sum</TD></TR><TR><TD height="20">TextCount</TD></TR></TBODY></TABLE><P></P><P></P><P><SPAN style="font-size: 13.3333330154419px;"><STRONG>Aggr</STRONG> is used with other functions to returns values based on a dimension.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">If you use this function with other function you can get multiple results.</SPAN></P><P>Look at Qlikview help to see examples</P><P></P><P>Example</P><P>Data set</P><P></P><P></P><P></P><P>load * Inline</P><P>[ Country,City,Sales</P><P>USA,New York,20</P><P>Russia,Moskau,10</P><P>Poland,Warsaw,15</P><P>USA,Los Angeles,20</P><P>Russia, Minsk,10</P><P>Poland, Lodz,15]</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87511_Untitled.png" style="height: auto;" /></P></BODY></HTML> Tue, 26 May 2015 09:51:36 GMT robert_mika 2015-05-26T09:51:36Z Aggregate function https://community.qlik.com/t5/QlikView/Aggregate-function/m-p/848596#M1002311 <HTML><HEAD></HEAD><BODY><P>Hi experts,</P><P></P><P>What is the difference between the aggregate and Aggr function and what is the use of that function?</P></BODY></HTML> Tue, 26 May 2015 08:31:31 GMT https://community.qlik.com/t5/QlikView/Aggregate-function/m-p/848596#M1002311 prabhas277 2015-05-26T08:31:31Z Re: Aggregate function https://community.qlik.com/t5/QlikView/Aggregate-function/m-p/848597#M1002313 <HTML><HEAD></HEAD><BODY><P>Read it here:<A href="https://community.qlik.com/docs/DOC-4777">QlikView Technical Brief - AGGR</A></P></BODY></HTML> Tue, 26 May 2015 08:43:16 GMT https://community.qlik.com/t5/QlikView/Aggregate-function/m-p/848597#M1002313 tresB 2015-05-26T08:43:16Z Re: Aggregate function https://community.qlik.com/t5/QlikView/Aggregate-function/m-p/848598#M1002315 <HTML><HEAD></HEAD><BODY><P><STRONG>Aggregation functions</STRONG> are function that accumulate values from multiple rows (like SUM, MIN.MAX)</P><P></P><P>Full list of Aggregation functions in Qlikview is quite large</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="108"><TBODY><TR><TD height="20" width="108">Avg</TD></TR><TR><TD height="20">Concat</TD></TR><TR><TD height="20">Correl</TD></TR><TR><TD height="20">Count</TD></TR><TR><TD height="20">FirstSortedValue</TD></TR><TR><TD height="20">Fractile</TD></TR><TR><TD height="20">InputAvg</TD></TR><TR><TD height="20">InputSum</TD></TR><TR><TD height="20">Kurtosis</TD></TR><TR><TD height="20">LastValue</TD></TR><TR><TD height="20">LINEST_B</TD></TR><TR><TD height="20">LINEST_DF</TD></TR><TR><TD height="20">LINEST_F</TD></TR><TR><TD height="20">LINEST_M</TD></TR><TR><TD height="20">LINEST_R2</TD></TR><TR><TD height="20">LINEST_SEB</TD></TR><TR><TD height="20">LINEST_SEM</TD></TR><TR><TD height="20">LINEST_SEY</TD></TR><TR><TD height="20">LINEST_SSREG</TD></TR><TR><TD height="20">LINEST_SSRESID</TD></TR><TR><TD height="20">Max</TD></TR><TR><TD height="20">MaxString</TD></TR><TR><TD height="20">Median</TD></TR><TR><TD height="20">Min</TD></TR><TR><TD height="20">MinString</TD></TR><TR><TD height="20">MissingCount</TD></TR><TR><TD height="20">Mode</TD></TR><TR><TD height="20">NullCount</TD></TR><TR><TD height="20">NumericCount</TD></TR><TR><TD height="20">Only</TD></TR><TR><TD height="20">Skew</TD></TR><TR><TD height="20">Stdev</TD></TR><TR><TD height="20">Sterr</TD></TR><TR><TD height="20">STEYX</TD></TR><TR><TD height="20">Sum</TD></TR><TR><TD height="20">TextCount</TD></TR></TBODY></TABLE><P></P><P></P><P><SPAN style="font-size: 13.3333330154419px;"><STRONG>Aggr</STRONG> is used with other functions to returns values based on a dimension.</SPAN></P><P><SPAN style="font-size: 13.3333330154419px;">If you use this function with other function you can get multiple results.</SPAN></P><P>Look at Qlikview help to see examples</P><P></P><P>Example</P><P>Data set</P><P></P><P></P><P></P><P>load * Inline</P><P>[ Country,City,Sales</P><P>USA,New York,20</P><P>Russia,Moskau,10</P><P>Poland,Warsaw,15</P><P>USA,Los Angeles,20</P><P>Russia, Minsk,10</P><P>Poland, Lodz,15]</P><P></P><P><IMG alt="Untitled.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/87511_Untitled.png" style="height: auto;" /></P></BODY></HTML> Tue, 26 May 2015 09:51:36 GMT https://community.qlik.com/t5/QlikView/Aggregate-function/m-p/848598#M1002315 robert_mika 2015-05-26T09:51:36Z