topic Re: AGGR function changes the value after changing the sorting table in QlikView https://community.qlik.com/t5/QlikView/AGGR-function-changes-the-value-after-changing-the-sorting-table/m-p/635862#M543922 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>The previous post is correct. The chart dimensions to the dimensions must be included in the dimensions in the aggr statement.</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Fri, 16 May 2014 09:11:14 GMT jonathandienst 2014-05-16T09:11:14Z AGGR function changes the value after changing the sorting table https://community.qlik.com/t5/QlikView/AGGR-function-changes-the-value-after-changing-the-sorting-table/m-p/635859#M543919 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P><IMG alt="AGGR1.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/58957_AGGR1.png" style="width: 620px; height: 454px;" /></P><P>but</P><P><IMG alt="AGGR2.png" class="jive-image" src="https://community.qlik.com/legacyfs/online/58961_AGGR2.png" style="width: 620px; height: 436px;" /></P><P class="almost_half_cell"><SPAN class="short_text" lang="en"><SPAN class="hps">Bringing the total number</SPAN> <SPAN class="hps">remains the same 22901814.<BR /></SPAN></SPAN></P><P></P><P><SPAN class="short_text" lang="en"><SPAN class="hps">What is it?</SPAN></SPAN></P></BODY></HTML> Fri, 16 May 2014 08:36:31 GMT https://community.qlik.com/t5/QlikView/AGGR-function-changes-the-value-after-changing-the-sorting-table/m-p/635859#M543919 vtatarnikov 2014-05-16T08:36:31Z Re: AGGR function changes the value after changing the sorting table https://community.qlik.com/t5/QlikView/AGGR-function-changes-the-value-after-changing-the-sorting-table/m-p/635860#M543920 <HTML><HEAD></HEAD><BODY><P>The problem is surely related to your data association ...</P></BODY></HTML> Fri, 16 May 2014 08:46:05 GMT https://community.qlik.com/t5/QlikView/AGGR-function-changes-the-value-after-changing-the-sorting-table/m-p/635860#M543920 alexandros17 2014-05-16T08:46:05Z Re: AGGR function changes the value after changing the sorting table https://community.qlik.com/t5/QlikView/AGGR-function-changes-the-value-after-changing-the-sorting-table/m-p/635861#M543921 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>i'am not sure what is it, but try to add your chart dimension into aggr () dimensions.</P><P>And maybe you may share sample allowing us to replicate problem and have a closer look on it.</P><P>regards</P><P>Darek</P></BODY></HTML> Fri, 16 May 2014 08:47:45 GMT https://community.qlik.com/t5/QlikView/AGGR-function-changes-the-value-after-changing-the-sorting-table/m-p/635861#M543921 2014-05-16T08:47:45Z Re: AGGR function changes the value after changing the sorting table https://community.qlik.com/t5/QlikView/AGGR-function-changes-the-value-after-changing-the-sorting-table/m-p/635862#M543922 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>The previous post is correct. The chart dimensions to the dimensions must be included in the dimensions in the aggr statement.</P><P></P><P>HTH</P><P>Jonathan</P></BODY></HTML> Fri, 16 May 2014 09:11:14 GMT https://community.qlik.com/t5/QlikView/AGGR-function-changes-the-value-after-changing-the-sorting-table/m-p/635862#M543922 jonathandienst 2014-05-16T09:11:14Z Re: AGGR function changes the value after changing the sorting table https://community.qlik.com/t5/QlikView/AGGR-function-changes-the-value-after-changing-the-sorting-table/m-p/635863#M543923 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Yes</SPAN><SPAN>, that's right</SPAN>. </SPAN></P><P><SPAN lang="en"><SPAN class="hps">=sum(Aggr(sum([Количество реализации])*FirstSortedValue([Цена закупки], -[Дата цены]), id_Товара, id_Магазина))</SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">works as it should</SPAN>. <SPAN class="hps">thank you very much.</SPAN></SPAN></P></BODY></HTML> Fri, 16 May 2014 09:13:57 GMT https://community.qlik.com/t5/QlikView/AGGR-function-changes-the-value-after-changing-the-sorting-table/m-p/635863#M543923 vtatarnikov 2014-05-16T09:13:57Z