topic Re: Aggregating sun based on two values in QlikView https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260816#M871080 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/message/1161049">count of values using group by</A></P><P></P><P>Hi Sunny can you please help me out in the above issue</P></BODY></HTML> Wed, 16 Nov 2016 17:47:33 GMT 2016-11-16T17:47:33Z Aggregating sun based on two values https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260811#M871075 <HTML><HEAD></HEAD><BODY><P>Hi all </P><P>I have a requirement where </P><P>Region&nbsp; country&nbsp; sales</P><P>Apac&nbsp;&nbsp;&nbsp;&nbsp; ind&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100</P><P>Apac&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; chn&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 90 </P><P>Mena&nbsp;&nbsp;&nbsp;&nbsp; eup&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80</P><P>Mena&nbsp;&nbsp;&nbsp;&nbsp; uk&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 40</P><P></P><P>I want to aggregate data based on region and country and show top values based on combination</P><P>I have to show in a single bar chart where </P><P>My dimension is region and sum of sales is expression</P><P></P><P>Output is as below</P><P>Region&nbsp;&nbsp;&nbsp;&nbsp; sales</P><P>Apac&nbsp;&nbsp; 100</P><P>Mena&nbsp;&nbsp; 80</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260811#M871075 2020-11-25T16:16:04Z Re: Aggregating sun based on two values https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260812#M871076 <HTML><HEAD></HEAD><BODY><P>May be like this</P><P></P><P>Dimension</P><P><STRONG>Region</STRONG></P><P></P><P>Expression</P><P><STRONG>Max(sales)</STRONG></P><P>or</P><P><STRONG>Max(Aggr(Sum(sales), Region, country))</STRONG></P></BODY></HTML> Wed, 16 Nov 2016 15:35:58 GMT https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260812#M871076 sunny_talwar 2016-11-16T15:35:58Z Re: Aggregating sun based on two values https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260813#M871077 <HTML><HEAD></HEAD><BODY><P>Try with Max(Sales)</P><P></P><P>OR Else Use Expression like</P><P></P><P>Aggr(Sum(Sales),Region)</P></BODY></HTML> Wed, 16 Nov 2016 15:39:09 GMT https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260813#M871077 Anil_Babu_Samineni 2016-11-16T15:39:09Z Re: Aggregating sun based on two values https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260814#M871078 <HTML><HEAD></HEAD><BODY><P>One more way is as below:</P><P></P><P>Dimension:</P><P><STRONG>Region</STRONG></P><P></P><P>Expression:</P><P><STRONG>FirstSortedValue(sales, -sales)</STRONG></P></BODY></HTML> Wed, 16 Nov 2016 15:42:26 GMT https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260814#M871078 trdandamudi 2016-11-16T15:42:26Z Re: Aggregating sun based on two values https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260815#M871079 <HTML><HEAD></HEAD><BODY><P>Thank u so much sunny it worked</P></BODY></HTML> Wed, 16 Nov 2016 17:45:44 GMT https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260815#M871079 2016-11-16T17:45:44Z Re: Aggregating sun based on two values https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260816#M871080 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/message/1161049">count of values using group by</A></P><P></P><P>Hi Sunny can you please help me out in the above issue</P></BODY></HTML> Wed, 16 Nov 2016 17:47:33 GMT https://community.qlik.com/t5/QlikView/Aggregating-sun-based-on-two-values/m-p/1260816#M871080 2016-11-16T17:47:33Z