Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Talk to Experts Tuesday, Live Q&A, September 22: Moving from QlikView to Qlik Sense. REGISTER
Showing results for 
Search instead for 
Did you mean: 

Split column and replace with associated fields and concatenate

Hi experts,

I have a field with information separated by '/' and this filed include Null values also i.e,"Route Segment" in the below example.
I need to create one more filed "Route Sales" based on filed "Route Segment".


"RouteSales" filed logic should be based on SalesRepID.
Routesegment is based on Segments  and it is a concatenation of segments
"Route Sales" is a concatenation of salesRepID but it will have some null values as same as in 'RouteSegment'


Could you please help me on this.

Labels (1)
0 Replies