topic What is Aggregation function? in QlikView https://community.qlik.com/t5/QlikView/What-is-Aggregation-function/m-p/128178#M752548 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am new to Qlikview</P><P>What is Aggregation function?</P><P>Plz Help.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT jonesbrown 2020-11-25T16:16:04Z What is Aggregation function? https://community.qlik.com/t5/QlikView/What-is-Aggregation-function/m-p/128178#M752548 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I am new to Qlikview</P><P>What is Aggregation function?</P><P>Plz Help.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/What-is-Aggregation-function/m-p/128178#M752548 jonesbrown 2020-11-25T16:16:04Z Re: What is Aggregation function? https://community.qlik.com/t5/QlikView/What-is-Aggregation-function/m-p/128179#M752549 <HTML><HEAD></HEAD><BODY><P>this one is duplicate</P><P><A href="https://community.qlik.com/thread/317641">What is Aggregation function?</A></P></BODY></HTML> Tue, 23 Oct 2018 08:05:45 GMT https://community.qlik.com/t5/QlikView/What-is-Aggregation-function/m-p/128179#M752549 YoussefBelloum 2018-10-23T08:05:45Z Re: What is Aggregation function? https://community.qlik.com/t5/QlikView/What-is-Aggregation-function/m-p/128180#M752550 <HTML><HEAD></HEAD><BODY><P style="margin: 0.5em 0; color: #222222; font-family: sans-serif; font-size: 14px;">A Wiki search that explains the concept very well:</P><P style="margin: 0.5em 0; color: #222222; font-family: sans-serif; font-size: 14px;">In <A class="mw-redirect" href="https://en.wikipedia.org/wiki/Database_management" style="color: #0b0080; background: none;" title="Database management">database management</A> an <STRONG>aggregate function</STRONG> is a <A href="https://en.wikipedia.org/wiki/Subroutine" style="color: #0b0080; background: none;" title="Subroutine">function</A> where the values of multiple rows are grouped together to form a single value of more significant meaning or measurement such as a <A class="mw-redirect" href="https://en.wikipedia.org/wiki/Set_(computer_science)" style="color: #0b0080; background: none;" title="Set (computer science)">set</A>, a <A class="mw-redirect" href="https://en.wikipedia.org/wiki/Set_(computer_science)#Multiset" style="color: #0b0080; background: none;" title="Set (computer science)">bag</A> or a <A class="mw-redirect" href="https://en.wikipedia.org/wiki/List_(computing)" style="color: #0b0080; background: none;" title="List (computing)">list</A>.</P><P style="margin: 0.5em 0; color: #222222; font-family: sans-serif; font-size: 14px;">Common aggregate functions include :</P><UL><LI><A href="https://en.wikipedia.org/wiki/Average" style="color: #0b0080; background: none;" title="Average">Average</A>() (i.e., <A href="https://en.wikipedia.org/wiki/Arithmetic_mean" style="color: #0b0080; background: none;" title="Arithmetic mean">arithmetic mean</A>)</LI><LI><A href="https://en.wikipedia.org/wiki/Counting" style="color: #0b0080; background: none;" title="Counting">Count</A>()</LI><LI><A class="mw-redirect" href="https://en.wikipedia.org/wiki/Maximum" style="color: #0b0080; background: none;" title="Maximum">Maximum</A>()</LI><LI>nanmean() (mean ignoring NaN values, also known as "nil" or "null")</LI><LI><A href="https://en.wikipedia.org/wiki/Median" style="color: #0b0080; background: none;" title="Median">Median</A>()</LI><LI><A class="mw-redirect" href="https://en.wikipedia.org/wiki/Minimum" style="color: #0b0080; background: none;" title="Minimum">Minimum</A>()</LI><LI><A href="https://en.wikipedia.org/wiki/Mode_(statistics)" style="color: #0b0080; background: none;" title="Mode (statistics)">Mode</A>()</LI><LI><A href="https://en.wikipedia.org/wiki/Summation" style="color: #0b0080; background: none;" title="Summation">Sum</A>()</LI></UL><P></P><P>Hope that helps.</P><P></P><P>You can use them in creating variables or in your expressions.</P><P></P><P>Best</P></BODY></HTML> Tue, 23 Oct 2018 08:15:44 GMT https://community.qlik.com/t5/QlikView/What-is-Aggregation-function/m-p/128180#M752550 Emma 2018-10-23T08:15:44Z