topic All possible unique combinations in QlikView https://community.qlik.com/t5/QlikView/All-possible-unique-combinations/m-p/82978#M13611 <HTML><HEAD></HEAD><BODY><P>Hi I have the following 3 columns. What I want is to be able to return all possible unique combinations of columns A,B and C in the order of A,B,C. For instance Men's comfortable beanie, Adult's Cosy hood and so on. Is this possible to do ? </P><P></P><P><SPAN style="font-family: 'Futura','sans-serif';">Column A,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Boy’s , </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Men’s ,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Child’s, </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Women’s</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Adult’s</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';"> </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Column B</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Comfortable,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Warm,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Snug,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Cosy, </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Silk</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';"> </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Column C</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Hat,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Beanie,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Cap,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Hood, </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Cover</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';"> </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';"> </SPAN></P></BODY></HTML> Fri, 09 Feb 2018 16:48:09 GMT Anonymous 2018-02-09T16:48:09Z All possible unique combinations https://community.qlik.com/t5/QlikView/All-possible-unique-combinations/m-p/82978#M13611 <HTML><HEAD></HEAD><BODY><P>Hi I have the following 3 columns. What I want is to be able to return all possible unique combinations of columns A,B and C in the order of A,B,C. For instance Men's comfortable beanie, Adult's Cosy hood and so on. Is this possible to do ? </P><P></P><P><SPAN style="font-family: 'Futura','sans-serif';">Column A,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Boy’s , </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Men’s ,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Child’s, </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Women’s</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Adult’s</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';"> </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Column B</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Comfortable,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Warm,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Snug,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Cosy, </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Silk</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';"> </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Column C</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Hat,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Beanie,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Cap,</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Hood, </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';">Cover</SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';"> </SPAN></P><P><SPAN style="font-family: 'Futura','sans-serif';"> </SPAN></P></BODY></HTML> Fri, 09 Feb 2018 16:48:09 GMT https://community.qlik.com/t5/QlikView/All-possible-unique-combinations/m-p/82978#M13611 Anonymous 2018-02-09T16:48:09Z