topic Re: combining articles in QlikView https://community.qlik.com/t5/QlikView/combining-articles/m-p/379773#M141663 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Yes you can do this in front end.</P><P>use the chart aggreggation function CONCAT to find the combination of articles and then count the frequency of occurence by using aggr.</P></BODY></HTML> Wed, 22 Aug 2012 09:48:27 GMT 2012-08-22T09:48:27Z combining articles https://community.qlik.com/t5/QlikView/combining-articles/m-p/379771#M141661 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I got a new problem: I have got orders and articles per order. My aim is to count, how many combinations of 2 articles I have got in the orders and how often the combination appears. </P><P>I have absolutely no idea how to start. Perhaps it is possible to solve this in a pivot-table?! </P><P></P><P>I would be delighted, if you have got any ideas or approaches to a solution.</P><P></P><P>I will add a picture to make my problem a bit more understandable, and a data file.</P><P></P><P>Thank you very much in advance,</P><P>Clemens</P></BODY></HTML> Wed, 22 Aug 2012 09:34:19 GMT https://community.qlik.com/t5/QlikView/combining-articles/m-p/379771#M141661 cscherer 2012-08-22T09:34:19Z Re: combining articles https://community.qlik.com/t5/QlikView/combining-articles/m-p/379772#M141662 <HTML><HEAD></HEAD><BODY><P>Maybe like attached (using a duplicate table linked by order)?</P></BODY></HTML> Wed, 22 Aug 2012 09:45:04 GMT https://community.qlik.com/t5/QlikView/combining-articles/m-p/379772#M141662 swuehl 2012-08-22T09:45:04Z Re: combining articles https://community.qlik.com/t5/QlikView/combining-articles/m-p/379773#M141663 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>Yes you can do this in front end.</P><P>use the chart aggreggation function CONCAT to find the combination of articles and then count the frequency of occurence by using aggr.</P></BODY></HTML> Wed, 22 Aug 2012 09:48:27 GMT https://community.qlik.com/t5/QlikView/combining-articles/m-p/379773#M141663 2012-08-22T09:48:27Z Re: combining articles https://community.qlik.com/t5/QlikView/combining-articles/m-p/379774#M141664 <HTML><HEAD></HEAD><BODY><P>this is it! incredibly fast!</P><P></P><P>thank you so much!!!</P></BODY></HTML> Wed, 22 Aug 2012 09:53:50 GMT https://community.qlik.com/t5/QlikView/combining-articles/m-p/379774#M141664 cscherer 2012-08-22T09:53:50Z Re: combining articles https://community.qlik.com/t5/QlikView/combining-articles/m-p/379775#M141665 <HTML><HEAD></HEAD><BODY><P>thank you, i`ll try out your proposal</P></BODY></HTML> Wed, 22 Aug 2012 09:54:40 GMT https://community.qlik.com/t5/QlikView/combining-articles/m-p/379775#M141665 cscherer 2012-08-22T09:54:40Z