Solved: subfield? what it gives? - Qlik Community

Anonymous · ‎2014-10-13

subfield(upper(country),'\',3) as u ?

PrashantSangle · ‎2014-10-13

Hi,

Subfield() gives you data before Delimeter

For example

subfield(upper(country),'\',3)

in this case if Country = india\abc\China\xya

then return data before 3 delimeter \ i.e. it returns

China as your output

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

View solution in original post

PrashantSangle · ‎2014-10-13

Hi,

Subfield() gives you data before Delimeter

For example

subfield(upper(country),'\',3)

in this case if Country = india\abc\China\xya

then return data before 3 delimeter \ i.e. it returns

China as your output

Regards

Great dreamer's dreams never fulfilled, they are always transcended.
Please appreciate our Qlik community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

ashfaq_haseeb · ‎2014-10-13

Hi it will return third position before \

Provide sample data.

Ex

=subfield(upper('Mohammed\Ashfaq\Ali'),'\',3)

will Return ALI

Regards

ASHFAQ

Anonymous · ‎2014-10-13

Hi,

this will return the third string delimited by '\' in your field country in upper case in a new field u.

Best regards

Stefan

senpradip007 · ‎2014-10-13

If country field containts value like

Input Output

AA\BB\CC\DD CC

AA\BB\CC CC

AA\BB\RR\DD\EE RR

Hope this example will help.