topic Re: Aggregation function in QlikView https://community.qlik.com/t5/QlikView/Aggregation-function/m-p/794990#M1030585 <HTML><HEAD></HEAD><BODY><P>how do you determine which CrispName to use?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Citi Bank N or <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Citi Bank PP</SPAN></SPAN></P></BODY></HTML> Thu, 12 Feb 2015 12:07:24 GMT giakoum 2015-02-12T12:07:24Z Aggregation function https://community.qlik.com/t5/QlikView/Aggregation-function/m-p/794989#M1030584 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Below is my requirement. Could some one please help me? since yesterday I am trying for it.</P><P></P><P></P><P>Expression - sum(EAD)</P><P></P><P>Ex</P><P></P><P> We need to group the data by CSAID and PARENT(Dimensions)</P><P></P><P>Total Dimensions in my pivot table/data like below</P><P></P><P>CrispName&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CSAID&nbsp;&nbsp; Period:&nbsp; P0&nbsp;&nbsp; P1&nbsp;&nbsp; P2&nbsp;&nbsp; P3</P><P>Citi Bank N&nbsp;&nbsp;&nbsp; Citi&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 100 10&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;&nbsp; 3</P><P>Citi Bank PP&nbsp; Citi&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp; 3&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp; 8</P><P>Citi Bank TT&nbsp;&nbsp; Citi&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 55&nbsp; 88</P><P></P><P>Result like:</P><P></P><P></P><P>CrispName&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Parent&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; CSAID&nbsp;&nbsp; Period:&nbsp;&nbsp;&nbsp; P0&nbsp;&nbsp;&nbsp;&nbsp; P1&nbsp;&nbsp; P2&nbsp;&nbsp; P3</P><P>Citi Bank N&nbsp;&nbsp;&nbsp; Citi&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 102&nbsp;&nbsp;&nbsp;&nbsp; 13&nbsp;&nbsp;&nbsp; 25&nbsp;&nbsp; 11</P><P>Citi Bank TT&nbsp;&nbsp; Citi&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10&nbsp;&nbsp;&nbsp; 55&nbsp; 88</P><P></P><P></P><P>Here Parent and CSAID should be unique.</P><P><BR /> </P></BODY></HTML> Thu, 12 Feb 2015 12:05:41 GMT https://community.qlik.com/t5/QlikView/Aggregation-function/m-p/794989#M1030584 priyarane 2015-02-12T12:05:41Z Re: Aggregation function https://community.qlik.com/t5/QlikView/Aggregation-function/m-p/794990#M1030585 <HTML><HEAD></HEAD><BODY><P>how do you determine which CrispName to use?</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Citi Bank N or <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Citi Bank PP</SPAN></SPAN></P></BODY></HTML> Thu, 12 Feb 2015 12:07:24 GMT https://community.qlik.com/t5/QlikView/Aggregation-function/m-p/794990#M1030585 giakoum 2015-02-12T12:07:24Z Re: Aggregation function https://community.qlik.com/t5/QlikView/Aggregation-function/m-p/794991#M1030586 <HTML><HEAD></HEAD><BODY><P>Hi Priya, you can change the first dimension to:</P><P>=Aggr(Minstring(CrispName), CSAID, Parent)</P><P></P><P>If you don't want the first alphabetical name, change MinString(CrispName) for the expression you need to select the correct name.</P></BODY></HTML> Thu, 12 Feb 2015 12:13:35 GMT https://community.qlik.com/t5/QlikView/Aggregation-function/m-p/794991#M1030586 rubenmarin 2015-02-12T12:13:35Z Re: Aggregation function https://community.qlik.com/t5/QlikView/Aggregation-function/m-p/794992#M1030587 <HTML><HEAD></HEAD><BODY><P>Hi Ioannis,</P><P></P><P>What ever name not a problem. If it is longest name then good.</P></BODY></HTML> Thu, 12 Feb 2015 12:36:51 GMT https://community.qlik.com/t5/QlikView/Aggregation-function/m-p/794992#M1030587 priyarane 2015-02-12T12:36:51Z Re: Aggregation function https://community.qlik.com/t5/QlikView/Aggregation-function/m-p/794993#M1030588 <HTML><HEAD></HEAD><BODY><P>RUBEN really Thank You.</P></BODY></HTML> Thu, 12 Feb 2015 13:21:17 GMT https://community.qlik.com/t5/QlikView/Aggregation-function/m-p/794993#M1030588 priyarane 2015-02-12T13:21:17Z