topic Re: Multiplication of aggregation results in QlikView https://community.qlik.com/t5/QlikView/Multiplication-of-aggregation-results/m-p/598389#M221538 <HTML><HEAD></HEAD><BODY><P>genial !</P></BODY></HTML> Tue, 16 Sep 2014 10:28:04 GMT MarcoWedel 2014-09-16T10:28:04Z Multiplication of aggregation results https://community.qlik.com/t5/QlikView/Multiplication-of-aggregation-results/m-p/598386#M221535 <HTML><HEAD></HEAD><BODY><P><SPAN lang="en"><SPAN class="hps">Hello,</SPAN> <BR /><BR /><SPAN class="hps">I am looking for</SPAN> <SPAN class="hps">an idea</SPAN> <SPAN class="hps">how to calculate</SPAN> <SPAN class="hps">the number of combinations</SPAN> <SPAN class="hps">of elements</SPAN> <SPAN class="hps">designated</SPAN> <SPAN class="hps">with respect to</SPAN> <SPAN class="hps">certain</SPAN> <SPAN class="hps">dimension</SPAN>. <BR /><BR /><SPAN class="hps">Let's say for example that</SPAN> <SPAN class="hps">the dimension</SPAN> <SPAN class="hps">coordinates</SPAN> <SPAN class="hps">are:</SPAN> <BR /><SPAN class="hps">A,</SPAN> <SPAN class="hps">B</SPAN>, C, <SPAN class="hps">D</SPAN> <BR /><BR /><SPAN class="hps">Expression</SPAN>: <BR /><SPAN class="hps">Aggr</SPAN> <SPAN class="atn hps">(</SPAN><SPAN class="atn">count (</SPAN>distinct <SPAN class="hps">value)</SPAN>, <SPAN class="hps">dim)</SPAN> <BR /><SPAN class="hps">gave</SPAN> <SPAN class="hps">the results</SPAN>: <BR /><SPAN class="hps">A-2</SPAN> <BR /><SPAN class="hps">B-3</SPAN> <BR /><SPAN class="hps">C</SPAN><SPAN class="atn">-</SPAN>4 <BR /><SPAN class="hps">D-2</SPAN> <BR /><BR /><SPAN class="hps">I wish to make</SPAN> <SPAN class="hps">on</SPAN> <SPAN class="hps">the</SPAN> <SPAN class="hps">basis of</SPAN> <SPAN class="hps">the next</SPAN> <SPAN class="hps">calculation</SPAN>, <SPAN class="hps">which</SPAN> <SPAN class="hps">will result in</SPAN> <SPAN class="hps">multiplying</SPAN> <SPAN class="hps">these values</SPAN> <SPAN class="hps">​​by themselves,</SPAN> <SPAN class="hps">so</SPAN> <SPAN class="hps">that as a result</SPAN> <SPAN class="hps">I get</SPAN>: <BR /><SPAN class="hps">2 *</SPAN> <SPAN class="hps">3 * 4</SPAN> <SPAN class="hps">* 2</SPAN> <SPAN class="hps">= 48</SPAN> <BR /></SPAN></P><P><SPAN lang="en"><BR /><SPAN class="hps"></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps"><BR /></SPAN></SPAN></P><P><SPAN lang="en"><SPAN class="hps">Thank you in advance</SPAN> <SPAN class="hps">for your suggestions</SPAN>. <BR /><SPAN class="hps">regards</SPAN> <BR /><SPAN class="hps">Darek</SPAN></SPAN></P></BODY></HTML> Mon, 05 May 2014 20:35:25 GMT https://community.qlik.com/t5/QlikView/Multiplication-of-aggregation-results/m-p/598386#M221535 2014-05-05T20:35:25Z Re: Multiplication of aggregation results https://community.qlik.com/t5/QlikView/Multiplication-of-aggregation-results/m-p/598387#M221536 <HTML><HEAD></HEAD><BODY><P>Try maybe</P><P></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">=Exp(Sum(Log( aggr( count(distinct value),dim))))</SPAN></P></BODY></HTML> Mon, 05 May 2014 20:53:51 GMT https://community.qlik.com/t5/QlikView/Multiplication-of-aggregation-results/m-p/598387#M221536 swuehl 2014-05-05T20:53:51Z Re: Multiplication of aggregation results https://community.qlik.com/t5/QlikView/Multiplication-of-aggregation-results/m-p/598388#M221537 <HTML><HEAD></HEAD><BODY><P><SPAN class="short_text" lang="en"><SPAN class="hps">Thanks,</SPAN> <BR /><SPAN class="hps">Mathematics</SPAN> <SPAN class="hps">is the</SPAN> <SPAN class="hps">queen of</SPAN> <SPAN class="hps">sciences</SPAN>!</SPAN></P><P><SPAN class="short_text" lang="en"><BR /></SPAN></P><P><SPAN class="short_text" lang="en">regards</SPAN></P><P><SPAN class="short_text" lang="en">Darek<BR /></SPAN></P></BODY></HTML> Mon, 05 May 2014 21:00:28 GMT https://community.qlik.com/t5/QlikView/Multiplication-of-aggregation-results/m-p/598388#M221537 2014-05-05T21:00:28Z Re: Multiplication of aggregation results https://community.qlik.com/t5/QlikView/Multiplication-of-aggregation-results/m-p/598389#M221538 <HTML><HEAD></HEAD><BODY><P>genial !</P></BODY></HTML> Tue, 16 Sep 2014 10:28:04 GMT https://community.qlik.com/t5/QlikView/Multiplication-of-aggregation-results/m-p/598389#M221538 MarcoWedel 2014-09-16T10:28:04Z Re: Multiplication of aggregation results https://community.qlik.com/t5/QlikView/Multiplication-of-aggregation-results/m-p/598390#M221539 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Tue, 16 Sep 2014 10:29:09 GMT https://community.qlik.com/t5/QlikView/Multiplication-of-aggregation-results/m-p/598390#M221539 2014-09-16T10:29:09Z