topic Use comparision code in QlikView https://community.qlik.com/t5/QlikView/Use-comparision-code/m-p/191769#M53731 <HTML><HEAD></HEAD><BODY><P>Hello I have a quite hard issue</P><P>I have a table vith product code and sold quantity. In a second table I have for some product code (not all) an association with other product codes used for comparation.</P><P>I want to build a pivot table with two colums for each product code, in the first I show the total sold for the code in the second the mean (if exist) of all comparable product code. I would want to do it with set analisys but I was unable to think/find a solution</P><P>I post a sample qvw</P><P></P><P>Thanks</P><P>Claudio</P></BODY></HTML> Fri, 28 Jan 2011 17:43:14 GMT 2011-01-28T17:43:14Z Use comparision code https://community.qlik.com/t5/QlikView/Use-comparision-code/m-p/191769#M53731 <HTML><HEAD></HEAD><BODY><P>Hello I have a quite hard issue</P><P>I have a table vith product code and sold quantity. In a second table I have for some product code (not all) an association with other product codes used for comparation.</P><P>I want to build a pivot table with two colums for each product code, in the first I show the total sold for the code in the second the mean (if exist) of all comparable product code. I would want to do it with set analisys but I was unable to think/find a solution</P><P>I post a sample qvw</P><P></P><P>Thanks</P><P>Claudio</P></BODY></HTML> Fri, 28 Jan 2011 17:43:14 GMT https://community.qlik.com/t5/QlikView/Use-comparision-code/m-p/191769#M53731 2011-01-28T17:43:14Z