topic I Want    New  field  'DefectCode'  From the field different data in QlikView https://community.qlik.com/t5/QlikView/I-Want-New-field-DefectCode-From-the-field-different-data/m-p/2063290#M1223341 <P>I have&nbsp; Table ' Production'&nbsp; &nbsp; have&nbsp; field&nbsp; 'RejectCode'&nbsp; , 'WorkOrder'&nbsp; ,&nbsp; &nbsp; 'QtyCode '&nbsp;&nbsp;</P> <P>EX&nbsp;&nbsp;WorkOrder =&nbsp;A0189050-09-000</P> <P>'<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1682132974971.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105556i32746FDC9038BDA6/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1682132974971.png" alt="Sxbbb_0-1682132974971.png" /></span></P> <P>and&nbsp;&nbsp;I have&nbsp; Table ' Scrap '&nbsp; &nbsp; have&nbsp; field&nbsp; 'ScrapCode'&nbsp; , 'WorkOrder'&nbsp; ,&nbsp; &nbsp; 'QtyScrap '</P> <P>EX&nbsp;&nbsp;WorkOrder =&nbsp;A0189050-09-000</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_1-1682133371398.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105557iDEE8A8301DF9E4D7/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_1-1682133371398.png" alt="Sxbbb_1-1682133371398.png" /></span></P> <P>&nbsp;</P> <P>But field 'RejectCode'&nbsp; is&nbsp; &nbsp;field 'ScrapCode ' + DefectCode field, which is set to extract other 'DefectCode 'data as 'DefectCode' field only.</P> <P>I Want&nbsp; &nbsp; New&nbsp; field&nbsp;&nbsp;'DefectCode'&nbsp;&nbsp;</P> <P>EX&nbsp;&nbsp;WorkOrder =&nbsp;A0189050-09-000</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_2-1682134967156.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105559iB775136227FE6058/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_2-1682134967156.png" alt="Sxbbb_2-1682134967156.png" /></span></P> <P>field 'RejectCode'&nbsp; is&nbsp; &nbsp;field 'ScrapCode ' + DefectCode field</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_3-1682135184987.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105560i97664C6594B824B7/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_3-1682135184987.png" alt="Sxbbb_3-1682135184987.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 22 Apr 2023 03:47:41 GMT Sxbbb 2023-04-22T03:47:41Z I Want    New  field  'DefectCode'  From the field different data https://community.qlik.com/t5/QlikView/I-Want-New-field-DefectCode-From-the-field-different-data/m-p/2063290#M1223341 <P>I have&nbsp; Table ' Production'&nbsp; &nbsp; have&nbsp; field&nbsp; 'RejectCode'&nbsp; , 'WorkOrder'&nbsp; ,&nbsp; &nbsp; 'QtyCode '&nbsp;&nbsp;</P> <P>EX&nbsp;&nbsp;WorkOrder =&nbsp;A0189050-09-000</P> <P>'<span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_0-1682132974971.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105556i32746FDC9038BDA6/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_0-1682132974971.png" alt="Sxbbb_0-1682132974971.png" /></span></P> <P>and&nbsp;&nbsp;I have&nbsp; Table ' Scrap '&nbsp; &nbsp; have&nbsp; field&nbsp; 'ScrapCode'&nbsp; , 'WorkOrder'&nbsp; ,&nbsp; &nbsp; 'QtyScrap '</P> <P>EX&nbsp;&nbsp;WorkOrder =&nbsp;A0189050-09-000</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_1-1682133371398.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105557iDEE8A8301DF9E4D7/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_1-1682133371398.png" alt="Sxbbb_1-1682133371398.png" /></span></P> <P>&nbsp;</P> <P>But field 'RejectCode'&nbsp; is&nbsp; &nbsp;field 'ScrapCode ' + DefectCode field, which is set to extract other 'DefectCode 'data as 'DefectCode' field only.</P> <P>I Want&nbsp; &nbsp; New&nbsp; field&nbsp;&nbsp;'DefectCode'&nbsp;&nbsp;</P> <P>EX&nbsp;&nbsp;WorkOrder =&nbsp;A0189050-09-000</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_2-1682134967156.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105559iB775136227FE6058/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_2-1682134967156.png" alt="Sxbbb_2-1682134967156.png" /></span></P> <P>field 'RejectCode'&nbsp; is&nbsp; &nbsp;field 'ScrapCode ' + DefectCode field</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Sxbbb_3-1682135184987.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/105560i97664C6594B824B7/image-size/medium?v=v2&amp;px=400" role="button" title="Sxbbb_3-1682135184987.png" alt="Sxbbb_3-1682135184987.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sat, 22 Apr 2023 03:47:41 GMT https://community.qlik.com/t5/QlikView/I-Want-New-field-DefectCode-From-the-field-different-data/m-p/2063290#M1223341 Sxbbb 2023-04-22T03:47:41Z