topic MAKE SOME CODE/VALUES AS ONE GROUP in QlikView https://community.qlik.com/t5/QlikView/MAKE-SOME-CODE-VALUES-AS-ONE-GROUP/m-p/1394893#M459258 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">hello'</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i have afiled that its name is status_code.</P><P style="font-size: 13.3333px;">this filed contian alot of codes' for exsamle:KB,KE,KD,G3,G4,G7,X,Z4...</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i want to make group/famlies of code.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i need it becasue i have to count them in groups.</P><P style="font-size: 13.3333px;">i also need to shw the barcodes that got status codes according to the groups/</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">the filed of the barcode calld Track_No</P><P style="font-size: 13.3333px;"></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">barcode</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">status_code</TH></TR><TR><TD style="padding: 2px;">1234</TD><TD style="padding: 2px;">G3</TD></TR><TR><TD style="padding: 2px;">5678</TD><TD style="padding: 2px;">KB</TD></TR><TR><TD>9102</TD><TD>kd</TD></TR><TR><TD>987</TD><TD>z4</TD></TR></TBODY></TABLE><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">G3, Z4 =group1</P><P style="font-size: 13.3333px;">kb,kd=group2</P></BODY></HTML> Thu, 19 Oct 2017 07:47:11 GMT y_vandijk 2017-10-19T07:47:11Z MAKE SOME CODE/VALUES AS ONE GROUP https://community.qlik.com/t5/QlikView/MAKE-SOME-CODE-VALUES-AS-ONE-GROUP/m-p/1394893#M459258 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333px;">hello'</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i have afiled that its name is status_code.</P><P style="font-size: 13.3333px;">this filed contian alot of codes' for exsamle:KB,KE,KD,G3,G4,G7,X,Z4...</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i want to make group/famlies of code.</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">i need it becasue i have to count them in groups.</P><P style="font-size: 13.3333px;">i also need to shw the barcodes that got status codes according to the groups/</P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">the filed of the barcode calld Track_No</P><P style="font-size: 13.3333px;"></P><TABLE border="1" class="jiveBorder" style="border: 1px solid #000000; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">barcode</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">status_code</TH></TR><TR><TD style="padding: 2px;">1234</TD><TD style="padding: 2px;">G3</TD></TR><TR><TD style="padding: 2px;">5678</TD><TD style="padding: 2px;">KB</TD></TR><TR><TD>9102</TD><TD>kd</TD></TR><TR><TD>987</TD><TD>z4</TD></TR></TBODY></TABLE><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;"></P><P style="font-size: 13.3333px;">G3, Z4 =group1</P><P style="font-size: 13.3333px;">kb,kd=group2</P></BODY></HTML> Thu, 19 Oct 2017 07:47:11 GMT https://community.qlik.com/t5/QlikView/MAKE-SOME-CODE-VALUES-AS-ONE-GROUP/m-p/1394893#M459258 y_vandijk 2017-10-19T07:47:11Z Re: MAKE SOME CODE/VALUES AS ONE GROUP https://community.qlik.com/t5/QlikView/MAKE-SOME-CODE-VALUES-AS-ONE-GROUP/m-p/1394894#M459259 <HTML><HEAD></HEAD><BODY><P>May be this?</P><P><STRONG>If(Match(status_code, 'G3','Z4'), 'group1' ,If(Match(status_code,'kd','z4'), 'group2'))</STRONG></P></BODY></HTML> Thu, 19 Oct 2017 14:46:26 GMT https://community.qlik.com/t5/QlikView/MAKE-SOME-CODE-VALUES-AS-ONE-GROUP/m-p/1394894#M459259 Anil_Babu_Samineni 2017-10-19T14:46:26Z