Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Subfield Index

I took a look at Subfield function in QlikView help, and additionaly I tried to find some examples and explanations o the Internet.

Unfortunately I did not found anything what gives a nice overview on how to use this function.

Anyway, I am using this function to get the [Full Name] and to concatenate this filed with ]Message] field

here is the code:

trim(Message) & ' (' & applymap('MapUsername2FullName', upper(subfield(Message,'"',4)) , upper(subfield(Message,'"',4))) & ')' as [New Message]

I am not getting [Full Name]

Has anybody any suggestion?

4 Replies

Could you please post the Sample Message text here?

For Example: UserName"FullName

SubField('UserName"FullName', '"', 2) will give you the FullName

Luminary Alumni
Luminary Alumni


Can you attach some sample values, so that it would be easier to understand your requirement and solve.



Not applicable

Yes, cerainly.

Here is an example of a Message item:

Call allocation: All XX licensed Named CALs are allocated. No CAL assigned to user "DOMAIN/abc123" - usage. denied.

I have to extract the following: DOMAIN/abc123


If the username is always between double quotes you can use the textbetween function:

textbetween(Message, '"','"') as UserName

The '"' is a double quote character between two single quotes.

talk is cheap, supply exceeds demand