Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
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.