Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Extracting values from a comma seperated string

Hey Guys,

I want to extract each company that is assigned to the Name in order to do a section access.

The two fields in the Screenshot below are two database fields.

I want the Result for the user "Barsch" to be like this:

Barsch, 100

Barsch, 110

Barsch, 120

Barsch, 210

Büch, 100

...

...

All suggestions welcome :-)

1 Solution

Accepted Solutions
MVP
MVP

Re: Extracting values from a comma seperated string

Load

     Name,

     SubField(Company,',') as Company

From TableName;

Use below sample example..

Load

  Name,

  SubField(Value,':') as Value Inline

[

  Name, Value

  A, 100:200:300:400

  B, 1000:2000:3000:4000

];

2 Replies
MVP
MVP

Re: Extracting values from a comma seperated string

Load

     Name,

     SubField(Company,',') as Company

From TableName;

Use below sample example..

Load

  Name,

  SubField(Value,':') as Value Inline

[

  Name, Value

  A, 100:200:300:400

  B, 1000:2000:3000:4000

];

Not applicable

Re: Extracting values from a comma seperated string

Perfect. I tried the SubField before, but I didn't get the desired result. My mistake was the 1 at the end.

Thanks for the quick reply :-)

Community Browser