<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: url (excel) in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/url-excel/m-p/825486#M290762</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;You will have to do it manually. Make a new column in excel and use formula &lt;SPAN style="color: #000000; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; background-color: #eeeeee;"&gt;=Hyperlink(A1).&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; background-color: #eeeeee;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Sun, 14 Dec 2014 08:53:31 GMT</pubDate>
    <dc:creator>Anonymous</dc:creator>
    <dc:date>2014-12-14T08:53:31Z</dc:date>
    <item>
      <title>url (excel)</title>
      <link>https://community.qlik.com/t5/QlikView/url-excel/m-p/825485#M290761</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;hi,&lt;/P&gt;&lt;P&gt;i have a table that one of the columns is link.&lt;/P&gt;&lt;P&gt;the text is not the link but when the user click on the text the link is open.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;when i export to excel the functionality not working.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;is ther any way to make the link work in the excel?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;tnx,&lt;/P&gt;&lt;P&gt;adi.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 14 Dec 2014 07:12:13 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/url-excel/m-p/825485#M290761</guid>
      <dc:creator>adiarnon</dc:creator>
      <dc:date>2014-12-14T07:12:13Z</dc:date>
    </item>
    <item>
      <title>Re: url (excel)</title>
      <link>https://community.qlik.com/t5/QlikView/url-excel/m-p/825486#M290762</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;You will have to do it manually. Make a new column in excel and use formula &lt;SPAN style="color: #000000; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; background-color: #eeeeee;"&gt;=Hyperlink(A1).&lt;/SPAN&gt;&lt;/P&gt;&lt;P&gt;&lt;SPAN style="color: #000000; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; font-size: 14px; background-color: #eeeeee;"&gt;&lt;BR /&gt;&lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 14 Dec 2014 08:53:31 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/url-excel/m-p/825486#M290762</guid>
      <dc:creator>Anonymous</dc:creator>
      <dc:date>2014-12-14T08:53:31Z</dc:date>
    </item>
    <item>
      <title>Re: url (excel)</title>
      <link>https://community.qlik.com/t5/QlikView/url-excel/m-p/825487#M290763</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;but the text in the excel is not the url...&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 14 Dec 2014 15:09:47 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/url-excel/m-p/825487#M290763</guid>
      <dc:creator>adiarnon</dc:creator>
      <dc:date>2014-12-14T15:09:47Z</dc:date>
    </item>
    <item>
      <title>Re: url (excel)</title>
      <link>https://community.qlik.com/t5/QlikView/url-excel/m-p/825488#M290764</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear Adi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can you please post an example?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;thanks,&lt;/P&gt;&lt;P&gt;Rajesh Vaswani&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Sun, 14 Dec 2014 16:24:53 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/url-excel/m-p/825488#M290764</guid>
      <dc:creator>rajeshvaswani77</dc:creator>
      <dc:date>2014-12-14T16:24:53Z</dc:date>
    </item>
  </channel>
</rss>

