https://community.qlik.com/t5/QlikView/Create-a-single-dimension-from-multiple-fields/m-p/1939177#M1219265 <P>Hello there,</P> <P>So essentially I want to create a single dimension by using their respective column/filename, say a Listbox called Asset, to make a selection on this laptop, desktops, server, and tablet.</P> <P>Many thanks.</P> <TABLE width="340"> <TBODY> <TR> <TD width="39">Code</TD> <TD width="73"># of laptop</TD> <TD width="86"># of desktop&nbsp;</TD> <TD width="78"># of server</TD> <TD width="64"># of tablet</TD> </TR> <TR> <TD>d1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> </TR> <TR> <TD>a2</TD> <TD>23</TD> <TD>3</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>a3</TD> <TD>12</TD> <TD>5</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>f1</TD> <TD>0</TD> <TD>14</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>e3</TD> <TD>0</TD> <TD>12</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>z2</TD> <TD>0</TD> <TD>5</TD> <TD>1</TD> <TD>0</TD> </TR> </TBODY> </TABLE> Thu, 02 Jun 2022 19:45:04 GMT BrunPierre 2022-06-02T19:45:04Z https://community.qlik.com/t5/QlikView/Create-a-single-dimension-from-multiple-fields/m-p/1939177#M1219265 <P>Hello there,</P> <P>So essentially I want to create a single dimension by using their respective column/filename, say a Listbox called Asset, to make a selection on this laptop, desktops, server, and tablet.</P> <P>Many thanks.</P> <TABLE width="340"> <TBODY> <TR> <TD width="39">Code</TD> <TD width="73"># of laptop</TD> <TD width="86"># of desktop&nbsp;</TD> <TD width="78"># of server</TD> <TD width="64"># of tablet</TD> </TR> <TR> <TD>d1</TD> <TD>0</TD> <TD>1</TD> <TD>0</TD> <TD>1</TD> </TR> <TR> <TD>a2</TD> <TD>23</TD> <TD>3</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>a3</TD> <TD>12</TD> <TD>5</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>f1</TD> <TD>0</TD> <TD>14</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>e3</TD> <TD>0</TD> <TD>12</TD> <TD>0</TD> <TD>0</TD> </TR> <TR> <TD>z2</TD> <TD>0</TD> <TD>5</TD> <TD>1</TD> <TD>0</TD> </TR> </TBODY> </TABLE> Thu, 02 Jun 2022 19:45:04 GMT https://community.qlik.com/t5/QlikView/Create-a-single-dimension-from-multiple-fields/m-p/1939177#M1219265 BrunPierre 2022-06-02T19:45:04Z https://community.qlik.com/t5/QlikView/Create-a-single-dimension-from-multiple-fields/m-p/1939265#M1219269 <P>Use crosstable load</P> <P><A href="https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083" target="_blank">https://community.qlik.com/t5/Qlik-Design-Blog/The-Crosstable-Load/ba-p/1468083</A></P> <P>&nbsp;</P> <P>&nbsp;</P> <LI-CODE lang="markup">crosstable(Asset,CountOf,1) Main: Load Code,[# of Laptop],[# of Desktop],[# of server],[# of tablet] From XyzSource;</LI-CODE> <P>&nbsp;</P> Fri, 03 Jun 2022 04:55:55 GMT https://community.qlik.com/t5/QlikView/Create-a-single-dimension-from-multiple-fields/m-p/1939265#M1219269 vinieme12 2022-06-03T04:55:55Z