Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for 
Search instead for 
Did you mean: 
khaycock
Creator
Creator

Subfield numerous spaces

Is it possible in QlikView to use Subfield to separate data after a second delimiter? I want to separate out each line where there the word Missing starts? So where it says Missing CYBERARK Missing SCCM, I want them split up to two lines of data.

 subfield.PNG

Labels (1)
2 Replies
marcus_malinow
Specialist III
Specialist III

Hi,

 

if you just use

Subfield([Your field], ' ') as Newfield

without the index parameter this will split the data across several rows (depending on how many subfields exist in the source field.

 

Marcus

felipe87
Contributor II
Contributor II

Great information! I really need this! I just went back to the help page and now I see it was there all the time.. But your explanation was more clearly and I think that should have an example of this on the help site.