topic Re: Not able to aggregate the data in QlikView https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447131#M800269 <HTML><HEAD></HEAD><BODY><P>Hello Anas,</P><P></P><P>try</P><P></P><P>aggr(sum(Structures),Structures) </P><P></P><P>or</P><P></P><P>sum(aggr(Structures,Structures))</P><P></P><P>I'am not exactly shure which of both works</P></BODY></HTML> Thu, 07 Dec 2017 14:38:25 GMT Ralf_Heukäufer 2017-12-07T14:38:25Z Not able to aggregate the data https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447128#M800266 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>&nbsp;&nbsp;&nbsp; I came across the following set of data and I am confused how to actually calculate(write the expression)-</P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Account</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Address</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Structures</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>amount</STRONG></TH></TR><TR><TD style="padding: 2px;">abc</TD><TD style="padding: 2px;">143 east street</TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1254</TD></TR><TR><TD style="padding: 2px;"><P><SPAN style="font-size: 13.3333px;">abc</SPAN></P></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">143 east street</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">1257</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">abc</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">143 east street</SPAN></TD><TD style="padding: 2px;">2</TD><TD style="padding: 2px;">45689</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">abc</SPAN></TD><TD style="padding: 2px;">124 wing</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">7895</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">abc</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">124 wing</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">475</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">abc</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">124 wing</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">3587</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">abc</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">124 wing</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">454</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">abc</SPAN></TD><TD style="padding: 2px;">12 ertsd</TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">4585</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">abc</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">12 ertsd</SPAN></TD><TD style="padding: 2px;">5</TD><TD style="padding: 2px;">75412</TD></TR><TR><TD style="padding: 2px;">xyz</TD><TD style="padding: 2px;">134 hinjew</TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">4546</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">xyz</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">134 hinjew</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">58794</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">xyz</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">134 hinjew</SPAN></TD><TD style="padding: 2px;">1</TD><TD style="padding: 2px;">451642</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">xyz</SPAN></TD><TD style="padding: 2px;">85,E blue</TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">121</TD></TR><TR><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">xyz</SPAN></TD><TD style="padding: 2px;"><SPAN style="font-size: 13.3333px;">85,E blue</SPAN></TD><TD style="padding: 2px;">4</TD><TD style="padding: 2px;">124578</TD></TR></TBODY></TABLE><P></P><P>&nbsp;&nbsp; <SPAN style="color: #ff0000;"> <STRONG style="text-decoration: underline;">I have a text object which should show total structures-</STRONG></SPAN></P><P><STRONG style="text-decoration: underline;"><SPAN style="color: #ff0000; text-decoration: underline;">If account <SPAN style="color: #0000ff; text-decoration: underline;">'abc'</SPAN> is selected so</SPAN> <SPAN style="color: #ff9900; text-decoration: underline;"><SPAN style="color: #0000ff; text-decoration: underline;">total structures=2+1+5=8</SPAN></SPAN></STRONG></P><P></P><P><SPAN style="color: #000000;">How should i write the expression for this, need help.</SPAN></P><P><SPAN style="color: #000000;"><BR /></SPAN></P><P><SPAN style="color: #000000;">Thanks</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447128#M800266 md_anasabbasi 2020-11-25T16:16:04Z Re: Not able to aggregate the data https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447129#M800267 <HTML><HEAD></HEAD><BODY><P>maybe, sum(distinct Structures) ?</P><P><IMG __jive_id="186097" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186097_Capture.PNG" style="height: 108px; width: 620px;" /></P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/186101_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 07 Dec 2017 14:36:20 GMT https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447129#M800267 OmarBenSalem 2017-12-07T14:36:20Z Re: Not able to aggregate the data https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447130#M800268 <HTML><HEAD></HEAD><BODY><P>One way is as below:</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186098_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P></BODY></HTML> Thu, 07 Dec 2017 14:36:40 GMT https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447130#M800268 trdandamudi 2017-12-07T14:36:40Z Re: Not able to aggregate the data https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447131#M800269 <HTML><HEAD></HEAD><BODY><P>Hello Anas,</P><P></P><P>try</P><P></P><P>aggr(sum(Structures),Structures) </P><P></P><P>or</P><P></P><P>sum(aggr(Structures,Structures))</P><P></P><P>I'am not exactly shure which of both works</P></BODY></HTML> Thu, 07 Dec 2017 14:38:25 GMT https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447131#M800269 Ralf_Heukäufer 2017-12-07T14:38:25Z Re: Not able to aggregate the data https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447132#M800270 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The above example will work on selection.</P><P></P><P>But if you want it say on a chart</P><P>Use</P><P>=SUM(AGGR(ONLY(Structures),Address))</P><P></P><P>Mark</P></BODY></HTML> Thu, 07 Dec 2017 14:44:56 GMT https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447132#M800270 Mark_Little 2017-12-07T14:44:56Z Re: Not able to aggregate the data https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447133#M800271 <HTML><HEAD></HEAD><BODY><P>sum(distinct Structures) would do it; why complicate things?</P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/186102_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Thu, 07 Dec 2017 14:47:54 GMT https://community.qlik.com/t5/QlikView/Not-able-to-aggregate-the-data/m-p/1447133#M800271 OmarBenSalem 2017-12-07T14:47:54Z