https://community.qlik.com/t5/QlikView/Split-column-and-replace-with-associated-fields-and-concatenate/m-p/1535538#M439157 <P>Hi experts,</P><P><BR />I have a field with information separated by '/' and this filed include Null values also i.e,"Route Segment" in the below example.<BR />I need to create one more filed "Route Sales" based on filed "Route Segment".</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Input" style="width: 372px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4583i71B62EA02134D463/image-size/large?v=v2&amp;px=999" role="button" title="Input.jpg" alt="Input" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Input</span></span></P><P>"RouteSales" filed logic should be based on SalesRepID.<BR />Routesegment is based on Segments&nbsp;&nbsp;and it<SPAN>&nbsp;is a concatenation of segments</SPAN><BR />"Route Sales" is a concatenation of salesRepID but it will have some null values as same as in 'RouteSegment'</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="output" style="width: 488px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4584i5C3A3648F8C81F1D/image-size/large?v=v2&amp;px=999" role="button" title="output.jpg" alt="output" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">output</span></span></P><P>Could you please help me on this.</P> Sat, 16 Nov 2024 04:39:06 GMT Arjunmallik_2019 2024-11-16T04:39:06Z https://community.qlik.com/t5/QlikView/Split-column-and-replace-with-associated-fields-and-concatenate/m-p/1535538#M439157 <P>Hi experts,</P><P><BR />I have a field with information separated by '/' and this filed include Null values also i.e,"Route Segment" in the below example.<BR />I need to create one more filed "Route Sales" based on filed "Route Segment".</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Input" style="width: 372px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4583i71B62EA02134D463/image-size/large?v=v2&amp;px=999" role="button" title="Input.jpg" alt="Input" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">Input</span></span></P><P>"RouteSales" filed logic should be based on SalesRepID.<BR />Routesegment is based on Segments&nbsp;&nbsp;and it<SPAN>&nbsp;is a concatenation of segments</SPAN><BR />"Route Sales" is a concatenation of salesRepID but it will have some null values as same as in 'RouteSegment'</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="output" style="width: 488px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/4584i5C3A3648F8C81F1D/image-size/large?v=v2&amp;px=999" role="button" title="output.jpg" alt="output" /><span class="lia-inline-image-caption" onclick="event.preventDefault();">output</span></span></P><P>Could you please help me on this.</P> Sat, 16 Nov 2024 04:39:06 GMT https://community.qlik.com/t5/QlikView/Split-column-and-replace-with-associated-fields-and-concatenate/m-p/1535538#M439157 Arjunmallik_2019 2024-11-16T04:39:06Z