topic Syntax adding calculation to set analysis expression in QlikView https://community.qlik.com/t5/QlikView/Syntax-adding-calculation-to-set-analysis-expression/m-p/436211#M557886 <HTML><HEAD></HEAD><BODY><P>Hi i would like to add an Exchange rate to the following formula. </P><P></P><P>sum({&lt;Bol_ID-={'003'}&gt;} aggr(distinct max({&lt;Bol_ID-={'003'}&gt;} Artikel.Lagersaldo) * max({&lt;Bol_ID-={'003'}&gt;} [Artikel.Vägt inpris]),Artikel.ArtikelNr)) </P><P></P><P></P><P><SPAN style="font-size: 10pt;">currency field name - BAS_CROSS_inv_FSG_KURS</SPAN></P><P></P><P></P><P>Desired result, however i am recieving wrong syntax.</P><P>sum({&lt;Bol_ID-={'003'}&gt;} aggr(distinct max({&lt;Bol_ID-={'003'}&gt;} Artikel.Lagersaldo) * max({&lt;Bol_ID-={'003'}&gt;} [Artikel.Vägt inpris] * BAS_CROSS_inv_FSG_KURS),Artikel.ArtikelNr)) - </P></BODY></HTML> Tue, 04 Jun 2013 11:45:29 GMT 2013-06-04T11:45:29Z Syntax adding calculation to set analysis expression https://community.qlik.com/t5/QlikView/Syntax-adding-calculation-to-set-analysis-expression/m-p/436211#M557886 <HTML><HEAD></HEAD><BODY><P>Hi i would like to add an Exchange rate to the following formula. </P><P></P><P>sum({&lt;Bol_ID-={'003'}&gt;} aggr(distinct max({&lt;Bol_ID-={'003'}&gt;} Artikel.Lagersaldo) * max({&lt;Bol_ID-={'003'}&gt;} [Artikel.Vägt inpris]),Artikel.ArtikelNr)) </P><P></P><P></P><P><SPAN style="font-size: 10pt;">currency field name - BAS_CROSS_inv_FSG_KURS</SPAN></P><P></P><P></P><P>Desired result, however i am recieving wrong syntax.</P><P>sum({&lt;Bol_ID-={'003'}&gt;} aggr(distinct max({&lt;Bol_ID-={'003'}&gt;} Artikel.Lagersaldo) * max({&lt;Bol_ID-={'003'}&gt;} [Artikel.Vägt inpris] * BAS_CROSS_inv_FSG_KURS),Artikel.ArtikelNr)) - </P></BODY></HTML> Tue, 04 Jun 2013 11:45:29 GMT https://community.qlik.com/t5/QlikView/Syntax-adding-calculation-to-set-analysis-expression/m-p/436211#M557886 2013-06-04T11:45:29Z Re: Syntax adding calculation to set analysis expression https://community.qlik.com/t5/QlikView/Syntax-adding-calculation-to-set-analysis-expression/m-p/436212#M557887 <HTML><HEAD></HEAD><BODY><P>Should the BAS_CROSS_inv_FSG_KURS be nested along with the max([Artikel.Vägt inpris]) ?</P><P>How about ...</P><P></P><P>sum({&lt;Bol_ID-={'003'}&gt;} aggr(distinct max({&lt;Bol_ID-={'003'}&gt;} Artikel.Lagersaldo) * </P><P>(max({&lt;Bol_ID-={'003'}&gt;} [Artikel.Vägt inpris]) * BAS_CROSS_inv_FSG_KURS),Artikel.ArtikelNr))</P><P></P><P>Jonathan</P></BODY></HTML> Tue, 04 Jun 2013 11:48:57 GMT https://community.qlik.com/t5/QlikView/Syntax-adding-calculation-to-set-analysis-expression/m-p/436212#M557887 Anonymous 2013-06-04T11:48:57Z