topic Group the Field Values in QlikView https://community.qlik.com/t5/QlikView/Group-the-Field-Values/m-p/848311#M1009844 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">HI Members</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please Suggest How to do this</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a Field <SPAN style="font-weight: inherit; font-style: inherit; font-family: 'arial black', 'avant garde';">Product_Name</SPAN> and their values are below, Now I want to Group them into two one in blue color as ProductA and rest as ProductB</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">and I need to create a list box in my app with ProductA, ProductB, when i chose a value from this list box corresponding values should be selected in the rest of the app, how&nbsp; Can I&nbsp; do this? Please Help</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: 'arial black', 'avant garde';">Product_Name </SPAN> </P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="148"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">AMP</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">TFD</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">FMT</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">KAR</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">LAS</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">MIL</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">SEA</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">SIP</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">SYK</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">527</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">528</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">529</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">530</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">531</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">532</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">533</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">534</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">535</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">536</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">537</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">538</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">546</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">570</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">571</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">572</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">573</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">940</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">965</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">243</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">244</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">245</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">248</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">251</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">252</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">255</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">256</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">263</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">265</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">355</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">356</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">400</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">575</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">576</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">577</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">578</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">579</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">580</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">581</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">582</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">583</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">584</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">585</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">586</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">587</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">588</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">589</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">590</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">591</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">592</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">593</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">594</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">595</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">596</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">597</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">598</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">599</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 29 Apr 2015 10:11:20 GMT 2015-04-29T10:11:20Z Group the Field Values https://community.qlik.com/t5/QlikView/Group-the-Field-Values/m-p/848311#M1009844 <HTML><HEAD></HEAD><BODY><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">HI Members</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Please Suggest How to do this</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">I have a Field <SPAN style="font-weight: inherit; font-style: inherit; font-family: 'arial black', 'avant garde';">Product_Name</SPAN> and their values are below, Now I want to Group them into two one in blue color as ProductA and rest as ProductB</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">and I need to create a list box in my app with ProductA, ProductB, when i chose a value from this list box corresponding values should be selected in the rest of the app, how&nbsp; Can I&nbsp; do this? Please Help</P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="font-weight: inherit; font-style: inherit; font-size: 13.3333330154419px; font-family: 'arial black', 'avant garde';">Product_Name </SPAN> </P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="148"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">AMP</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">TFD</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">FMT</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">KAR</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">LAS</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">MIL</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">SEA</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">SIP</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">SYK</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">527</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">528</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">529</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">530</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">531</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">532</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">533</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">534</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">535</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">536</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;"><SPAN style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3366ff;">537</SPAN></TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">538</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">546</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">570</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">571</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">572</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">573</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">940</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl63" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">965</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">243</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">244</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">245</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">248</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">251</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">252</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">255</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">256</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">263</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">265</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">355</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">356</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">400</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">575</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">576</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">577</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">578</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">579</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">580</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">581</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">582</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">583</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">584</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">585</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">586</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">587</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">588</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">589</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">590</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">591</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">592</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">593</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">594</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">595</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">596</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">597</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">598</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl64" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;">599</TD></TR></TBODY></TABLE></BODY></HTML> Wed, 29 Apr 2015 10:11:20 GMT https://community.qlik.com/t5/QlikView/Group-the-Field-Values/m-p/848311#M1009844 2015-04-29T10:11:20Z Re: Group the Field Values https://community.qlik.com/t5/QlikView/Group-the-Field-Values/m-p/848312#M1009845 <HTML><HEAD></HEAD><BODY><P>use apply map </P><P><A href="https://community.qlik.com/qlik-blogpost/2756">Don't join - use Applymap instead</A></P></BODY></HTML> Wed, 29 Apr 2015 15:38:20 GMT https://community.qlik.com/t5/QlikView/Group-the-Field-Values/m-p/848312#M1009845 ramoncova06 2015-04-29T15:38:20Z