topic Makring multiple aggregations in QlikView https://community.qlik.com/t5/QlikView/Makring-multiple-aggregations/m-p/321448#M1188284 <HTML><HEAD></HEAD><BODY><P>Dear all, </P><P></P><P>I'm a newbie on Qlik and I'm fighting to solve a simple issue.</P><P>I'm trying to make a chart when I show all the customers that acquire one article, how many acquire 2, 3 and so on but I have a source table which gives me the customers and the article.</P><P>I know article could be bougth by many costomers and customers may buy many articles... How I can make this selections?</P><P>I tryied using the AGGR functions but, due to big amounts of data, it hangs with no results?</P><P></P><P>Can anyone help me? </P></BODY></HTML> Sat, 03 Sep 2011 08:41:24 GMT 2011-09-03T08:41:24Z Makring multiple aggregations https://community.qlik.com/t5/QlikView/Makring-multiple-aggregations/m-p/321448#M1188284 <HTML><HEAD></HEAD><BODY><P>Dear all, </P><P></P><P>I'm a newbie on Qlik and I'm fighting to solve a simple issue.</P><P>I'm trying to make a chart when I show all the customers that acquire one article, how many acquire 2, 3 and so on but I have a source table which gives me the customers and the article.</P><P>I know article could be bougth by many costomers and customers may buy many articles... How I can make this selections?</P><P>I tryied using the AGGR functions but, due to big amounts of data, it hangs with no results?</P><P></P><P>Can anyone help me? </P></BODY></HTML> Sat, 03 Sep 2011 08:41:24 GMT https://community.qlik.com/t5/QlikView/Makring-multiple-aggregations/m-p/321448#M1188284 2011-09-03T08:41:24Z Makring multiple aggregations https://community.qlik.com/t5/QlikView/Makring-multiple-aggregations/m-p/321449#M1188285 <HTML><HEAD></HEAD><BODY><P>Hi Luciano!</P><P></P><P>Try to do this thing in the script.</P><P>Write Something like:</P><P></P><P>Load</P><P>Article,</P><P>Count(Customer) as Customercount</P><P>from abc.qvd group by Article;</P><P></P><P>u can also link this table with the main table by Article.</P></BODY></HTML> Sun, 04 Sep 2011 15:47:55 GMT https://community.qlik.com/t5/QlikView/Makring-multiple-aggregations/m-p/321449#M1188285 2011-09-04T15:47:55Z