Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

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

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".

InputInput

"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'

outputoutput

Could you please help me on this.

Labels (1)
0 Replies