topic One Listbox for multiple FieldValues in QlikView https://community.qlik.com/t5/QlikView/One-Listbox-for-multiple-FieldValues/m-p/369134#M137230 <HTML><HEAD></HEAD><BODY><DIV><P>Hello,</P><P>hope someone can help me with the following question.</P><P></P><P>I´ve the following table "Categories":</P></DIV><DIV> </DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="202" style="border: 1px solid rgb(0, 0, 0); width: 326px; height: 74px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><P><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></P></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>CategoryColor</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><P><SPAN style="color: #ffffff;"><STRONG>CategorySize</STRONG></SPAN></P></TH></TR><TR><TD><DIV>1000</DIV></TD><TD>color</TD><TD>logo</TD><TD>size</TD></TR><TR><TD>1000</TD><TD>color</TD><TD>logo</TD><TD></TD></TR><TR><TD>1001</TD><TD>color</TD><TD></TD><TD>size</TD></TR><TR><TD>1002</TD><TD></TD><TD></TD><TD>size</TD></TR><TR><TD>1002</TD><TD>color</TD><TD>logo</TD><TD>size</TD></TR><TR><TD>1002</TD><TD>color</TD><TD>logo</TD><TD></TD></TR><TR><TD>1003</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>1004</TD><TD>color</TD><TD>logo</TD><TD>size</TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV> </DIV><DIV><P>The problem is now I want to create ONE Listbox with all 3 Categories.</P><P></P><P>At the moment it´s only possible to create one Listbox for EACH category.</P><P></P><P>I think I have to create a new Field which contains AllCategories: color, logo, size and have to create a new table?! Maybe via subfield.</P><P>The problems therefore are the gaps by generating the new Field “AllCategories” in the table "Categories". </P><P></P><P>If would appreciate if someone could help. </P><P></P><P>Thanks</P></DIV></BODY></HTML> Thu, 26 Jul 2012 10:11:49 GMT 2012-07-26T10:11:49Z One Listbox for multiple FieldValues https://community.qlik.com/t5/QlikView/One-Listbox-for-multiple-FieldValues/m-p/369134#M137230 <HTML><HEAD></HEAD><BODY><DIV><P>Hello,</P><P>hope someone can help me with the following question.</P><P></P><P>I´ve the following table "Categories":</P></DIV><DIV> </DIV><DIV><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="202" style="border: 1px solid rgb(0, 0, 0); width: 326px; height: 74px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><P><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></P></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>CategoryColor</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><P><SPAN style="color: #ffffff;"><STRONG>CategorySize</STRONG></SPAN></P></TH></TR><TR><TD><DIV>1000</DIV></TD><TD>color</TD><TD>logo</TD><TD>size</TD></TR><TR><TD>1000</TD><TD>color</TD><TD>logo</TD><TD></TD></TR><TR><TD>1001</TD><TD>color</TD><TD></TD><TD>size</TD></TR><TR><TD>1002</TD><TD></TD><TD></TD><TD>size</TD></TR><TR><TD>1002</TD><TD>color</TD><TD>logo</TD><TD>size</TD></TR><TR><TD>1002</TD><TD>color</TD><TD>logo</TD><TD></TD></TR><TR><TD>1003</TD><TD></TD><TD></TD><TD></TD></TR><TR><TD>1004</TD><TD>color</TD><TD>logo</TD><TD>size</TD></TR></TBODY></TABLE></DIV><DIV> </DIV><DIV> </DIV><DIV><P>The problem is now I want to create ONE Listbox with all 3 Categories.</P><P></P><P>At the moment it´s only possible to create one Listbox for EACH category.</P><P></P><P>I think I have to create a new Field which contains AllCategories: color, logo, size and have to create a new table?! Maybe via subfield.</P><P>The problems therefore are the gaps by generating the new Field “AllCategories” in the table "Categories". </P><P></P><P>If would appreciate if someone could help. </P><P></P><P>Thanks</P></DIV></BODY></HTML> Thu, 26 Jul 2012 10:11:49 GMT https://community.qlik.com/t5/QlikView/One-Listbox-for-multiple-FieldValues/m-p/369134#M137230 2012-07-26T10:11:49Z Re: One Listbox for multiple FieldValues https://community.qlik.com/t5/QlikView/One-Listbox-for-multiple-FieldValues/m-p/369135#M137231 <HTML><HEAD></HEAD><BODY><P>You should be able to use CrossTable to reformat the table the way you want</P></BODY></HTML> Thu, 26 Jul 2012 10:26:09 GMT https://community.qlik.com/t5/QlikView/One-Listbox-for-multiple-FieldValues/m-p/369135#M137231 Anonymous 2012-07-26T10:26:09Z Re: One Listbox for multiple FieldValues https://community.qlik.com/t5/QlikView/One-Listbox-for-multiple-FieldValues/m-p/369136#M137232 <HTML><HEAD></HEAD><BODY><P>Hey,</P><P>I think if I use crosstable the problem will be that the Table will get “new” ID´s. Consequently, the other problem would be that I also woudn´t know which ID´s have for example: color and size, size and logo,&nbsp; or only color, … </P></BODY></HTML> Thu, 26 Jul 2012 14:30:08 GMT https://community.qlik.com/t5/QlikView/One-Listbox-for-multiple-FieldValues/m-p/369136#M137232 2012-07-26T14:30:08Z