topic Is it possible to make ... in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-to-make/m-p/366590#M136368 <HTML><HEAD></HEAD><BODY><P>Yes you can. But you will need to use an Aggr function. Example:</P><P></P><P>=Aggr(distinct Count(OrderID),Product)</P><P></P><P>will create an array of numbers that represent "On how many orders does the the product X appear?"</P><P></P><P>Basically, the Aggr function creates an array using the first parameter of the Aggr function (which must be an aggregation) and the second (third, fourth, ...) parameter is equivalent to the GROUP BY in SQL.</P><P></P><P>/HIC</P></BODY></HTML> Fri, 23 Mar 2012 15:07:25 GMT hic 2012-03-23T15:07:25Z Is it possible to make ... https://community.qlik.com/t5/QlikView/Is-it-possible-to-make/m-p/366589#M136367 <HTML><HEAD></HEAD><BODY><P>Is it possible to make an aggregation inside of an expression of a CALCULATED dimension?</P><P></P><P>I have a table with a calculated dimension and I need to use an aggregation on that... but I am not sure that is posssible...</P><P></P><P></P><P>Let me know</P><P>Thanks in advance </P></BODY></HTML> Fri, 23 Mar 2012 10:43:55 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make/m-p/366589#M136367 2012-03-23T10:43:55Z Is it possible to make ... https://community.qlik.com/t5/QlikView/Is-it-possible-to-make/m-p/366590#M136368 <HTML><HEAD></HEAD><BODY><P>Yes you can. But you will need to use an Aggr function. Example:</P><P></P><P>=Aggr(distinct Count(OrderID),Product)</P><P></P><P>will create an array of numbers that represent "On how many orders does the the product X appear?"</P><P></P><P>Basically, the Aggr function creates an array using the first parameter of the Aggr function (which must be an aggregation) and the second (third, fourth, ...) parameter is equivalent to the GROUP BY in SQL.</P><P></P><P>/HIC</P></BODY></HTML> Fri, 23 Mar 2012 15:07:25 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make/m-p/366590#M136368 hic 2012-03-23T15:07:25Z Is it possible to make ... https://community.qlik.com/t5/QlikView/Is-it-possible-to-make/m-p/366591#M136369 <HTML><HEAD></HEAD><BODY><P>Henric is right...&nbsp; but, in some cases, the aggregation could be a contradiction with the dimmention.</P><P></P><P>Please, tell us the Calculated Dimmention you have and the Aggregated expression you need.</P></BODY></HTML> Fri, 23 Mar 2012 15:43:10 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-to-make/m-p/366591#M136369 sebastiandperei 2012-03-23T15:43:10Z