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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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

Labels (1)
1 Solution

Accepted Solutions
rwunderlich
MVP
MVP

subfield(WWW, '.', -1)

-Rob

View solution in original post

3 Replies
rwunderlich
MVP
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