topic Re: How to combine 2 different fields to make them one dimension instead of two in QlikView https://community.qlik.com/t5/QlikView/How-to-combine-2-different-fields-to-make-them-one-dimension/m-p/694964#M1055933 <HTML><HEAD></HEAD><BODY><P>Hi abdallah,</P><P></P><P>the easiest way would&nbsp; be to concatenate them into one "compount_field" in a LOAD_statement, using the &amp;</P><P></P><P>LOAD</P><P>&nbsp;&nbsp; ...</P><P>&nbsp;&nbsp; ([field1] &amp; '|' &amp; [field2]) as [new_dimension]</P><P>&nbsp;&nbsp; ...</P><P>FROM</P><P>...</P><P>Of&nbsp; course, you could do the same on the GUI.</P><P>HTH</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Thu, 09 Oct 2014 15:17:31 GMT datanibbler 2014-10-09T15:17:31Z How to combine 2 different fields to make them one dimension instead of two https://community.qlik.com/t5/QlikView/How-to-combine-2-different-fields-to-make-them-one-dimension/m-p/694963#M1055932 <HTML><HEAD></HEAD><BODY><P>How to combine 2 different fields to make them one dimension instead of two</P></BODY></HTML> Thu, 09 Oct 2014 15:14:31 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-different-fields-to-make-them-one-dimension/m-p/694963#M1055932 2014-10-09T15:14:31Z Re: How to combine 2 different fields to make them one dimension instead of two https://community.qlik.com/t5/QlikView/How-to-combine-2-different-fields-to-make-them-one-dimension/m-p/694964#M1055933 <HTML><HEAD></HEAD><BODY><P>Hi abdallah,</P><P></P><P>the easiest way would&nbsp; be to concatenate them into one "compount_field" in a LOAD_statement, using the &amp;</P><P></P><P>LOAD</P><P>&nbsp;&nbsp; ...</P><P>&nbsp;&nbsp; ([field1] &amp; '|' &amp; [field2]) as [new_dimension]</P><P>&nbsp;&nbsp; ...</P><P>FROM</P><P>...</P><P>Of&nbsp; course, you could do the same on the GUI.</P><P>HTH</P><P>Best regards,</P><P></P><P>DataNibbler</P></BODY></HTML> Thu, 09 Oct 2014 15:17:31 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-different-fields-to-make-them-one-dimension/m-p/694964#M1055933 datanibbler 2014-10-09T15:17:31Z Re: How to combine 2 different fields to make them one dimension instead of two https://community.qlik.com/t5/QlikView/How-to-combine-2-different-fields-to-make-them-one-dimension/m-p/694965#M1055934 <HTML><HEAD></HEAD><BODY><P>you could combine them in the load script as:</P><P>Load</P><P>Field1&amp;Field2 as NewField </P><P>;</P><P>(You could also add a character separator if it would be more meaningful)</P><P>or you can use a calculated dimension and do the same thing as the load script, just use that syntax in your calculated dimension. </P></BODY></HTML> Thu, 09 Oct 2014 15:18:02 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-different-fields-to-make-them-one-dimension/m-p/694965#M1055934 cspencer3 2014-10-09T15:18:02Z Re: How to combine 2 different fields to make them one dimension instead of two https://community.qlik.com/t5/QlikView/How-to-combine-2-different-fields-to-make-them-one-dimension/m-p/694966#M1055935 <HTML><HEAD></HEAD><BODY><P>thank you very much!</P></BODY></HTML> Fri, 10 Oct 2014 07:24:41 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-different-fields-to-make-them-one-dimension/m-p/694966#M1055935 2014-10-10T07:24:41Z Re: How to combine 2 different fields to make them one dimension instead of two https://community.qlik.com/t5/QlikView/How-to-combine-2-different-fields-to-make-them-one-dimension/m-p/694967#M1055936 <HTML><HEAD></HEAD><BODY><P>Delay between me typing and posting; DataNibbler beat me to it. </P></BODY></HTML> Fri, 10 Oct 2014 13:53:02 GMT https://community.qlik.com/t5/QlikView/How-to-combine-2-different-fields-to-make-them-one-dimension/m-p/694967#M1055936 cspencer3 2014-10-10T13:53:02Z