Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Subfield issue

Hi,

Consider the following data:

WWW

google.com

bing.com

facebook.com

google.de
google.fr
google.co.uk
google.es
bing.it
google.ca
bing.nl
google.se
google.pl

How do I get the domain ? In fact I want the resulting field to return:

DOMAIN

.com

.de

.fr

.uk

.es

.it

.ca

.nl

.se

.pl

How to accomplish that in the script using for instance subfield ?

Thanks,

David

1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

subfield(WWW, '.', -1)

-Rob

View solution in original post

3 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

subfield(WWW, '.', -1)

-Rob

Anonymous
Not applicable
Author

Hi Mr. Wunderlich,

Thanks for the reply - such a simple solution 🙂

BR,

David

Anonymous
Not applicable
Author

Hi again Mr. Wunderlich,

Sorry to bother you but could you please have a look at my post regarding Google Static World Heat Map. I believe you have some good input - since the original post of the app was made by you way back in the days + plus you had some good examples in your cookbook (regarding Google static map API) which I can't find right now.

Google Static map sorting issue

Highly appreciated!

Thanks,

David