topic Re: Subfield issue in QlikView https://community.qlik.com/t5/QlikView/Subfield-issue/m-p/119315#M18387 <HTML><HEAD></HEAD><BODY><P>Hi Mr. Wunderlich,</P><P></P><P>Thanks for the reply - such a simple solution <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P><P></P><P>BR,</P><P>David</P></BODY></HTML> Thu, 13 Sep 2018 06:57:40 GMT Anonymous 2018-09-13T06:57:40Z Subfield issue https://community.qlik.com/t5/QlikView/Subfield-issue/m-p/119313#M18385 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Consider the following data:</P><P></P><P><STRONG>WWW</STRONG></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 98px;"><TBODY><TR><TD class="xl63" height="17" width="98"><P>google.com</P><P>bing.com</P><P>facebook.com</P></TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">google.de</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">google.fr</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">google.co.uk</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">google.es</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">bing.it</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">google.ca</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">bing.nl</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">google.se</TD></TR><TR><TD class="xl63" height="17" style="border-top: none;">google.pl</TD></TR></TBODY></TABLE><P></P><P>How do I get the domain ? In fact I want the resulting field to return:</P><P></P><P><STRONG>DOMAIN</STRONG></P><P>.com</P><P>.de</P><P>.fr</P><P>.uk</P><P>.es</P><P>.it</P><P>.ca</P><P>.nl</P><P>.se</P><P>.pl</P><P></P><P>How to accomplish that in the script using for instance subfield ?</P><P></P><P></P><P>Thanks,</P><P>David</P></BODY></HTML> Wed, 12 Sep 2018 08:14:48 GMT https://community.qlik.com/t5/QlikView/Subfield-issue/m-p/119313#M18385 Anonymous 2018-09-12T08:14:48Z Re: Subfield issue https://community.qlik.com/t5/QlikView/Subfield-issue/m-p/119314#M18386 <HTML><HEAD></HEAD><BODY><P>subfield(WWW, '.', -1)</P><P></P><P>-Rob</P></BODY></HTML> Wed, 12 Sep 2018 17:24:03 GMT https://community.qlik.com/t5/QlikView/Subfield-issue/m-p/119314#M18386 rwunderlich 2018-09-12T17:24:03Z Re: Subfield issue https://community.qlik.com/t5/QlikView/Subfield-issue/m-p/119315#M18387 <HTML><HEAD></HEAD><BODY><P>Hi Mr. Wunderlich,</P><P></P><P>Thanks for the reply - such a simple solution <span class="lia-unicode-emoji" title=":slightly_smiling_face:">🙂</span> </P><P></P><P>BR,</P><P>David</P></BODY></HTML> Thu, 13 Sep 2018 06:57:40 GMT https://community.qlik.com/t5/QlikView/Subfield-issue/m-p/119315#M18387 Anonymous 2018-09-13T06:57:40Z Re: Subfield issue https://community.qlik.com/t5/QlikView/Subfield-issue/m-p/119316#M18388 <HTML><HEAD></HEAD><BODY><P>Hi again Mr. Wunderlich,</P><P>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.</P><P></P><P><A href="https://community.qlik.com/thread/313828">Google Static map sorting issue</A></P><P></P><P>Highly appreciated!</P><P></P><P>Thanks,</P><P>David</P></BODY></HTML> Fri, 14 Sep 2018 06:19:08 GMT https://community.qlik.com/t5/QlikView/Subfield-issue/m-p/119316#M18388 Anonymous 2018-09-14T06:19:08Z