Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

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.


Labels (1)
2 Replies
Specialist III
Specialist III



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.



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.