<?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: How to obtain the url string? in QlikView</title>
    <link>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308638#M113948</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi BlackRock,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;I have a situation where in i need to pass the Input Parameter from the URL (Query String) to the stored procedure and bind the dashboard.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Ex: www.google.com/ID=4&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;I am trying to access the above ID field in a variable and then pass to the Stored Procedure as&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;sql exec sproc $(ID);&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;I am facing issues to access the query string value and also to bind a variable to the stored procedure dynamically instead of declaring as $(ID)=1.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Please let me know if you find any solutions.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Sai Krishna&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Wed, 26 Dec 2012 11:35:21 GMT</pubDate>
    <dc:creator />
    <dc:date>2012-12-26T11:35:21Z</dc:date>
    <item>
      <title>How to obtain the url string?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308630#M113940</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt; For some background on my issue see here: &lt;A _jive_internal="true" href="https://community.qlik.com/message/126265"&gt;http://community.qlik.com/message/126265&lt;/A&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I would basically like to parse the url string to gather parameters that I will use for field selections.&amp;nbsp; &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have been unsuccessful in obtaining the url string, does anyone have any suggestions or ideas?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks!&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 21 Jun 2011 22:20:27 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308630#M113940</guid>
      <dc:creator />
      <dc:date>2011-06-21T22:20:27Z</dc:date>
    </item>
    <item>
      <title>How to obtain the url string?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308631#M113941</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Just wanted to bump this, anyone know how to store the url string for parsing in QlikView?&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 23 Jun 2011 17:39:20 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308631#M113941</guid>
      <dc:creator />
      <dc:date>2011-06-23T17:39:20Z</dc:date>
    </item>
    <item>
      <title>How to obtain the url string?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308632#M113942</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In the QVW documnet create a variable tabname as an example from Menu -&amp;gt; Settings -&amp;gt; Variable Overview.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;So while passing any value to pass any value to this variable from url, create the url as&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;qvp://servername/applicationname.qvw?tabname=abc&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;In the application us just refer the variable name tabname to fetch the value that passed in url.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Please try and let me know still didnt get solved your issue.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Cheers.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 24 Jun 2011 10:08:37 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308632#M113942</guid>
      <dc:creator />
      <dc:date>2011-06-24T10:08:37Z</dc:date>
    </item>
    <item>
      <title>How to obtain the url string?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308633#M113943</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi BlackRockS&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;could you please put some example code so that it is more clear what is &lt;/P&gt;&lt;P&gt;"In the application us just refer the variable name tabname to fetch the value that passed in url."&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks a lot.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Mon, 18 Jul 2011 16:51:34 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308633#M113943</guid>
      <dc:creator />
      <dc:date>2011-07-18T16:51:34Z</dc:date>
    </item>
    <item>
      <title>Re: How to obtain the url string?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308634#M113944</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;you need to have your url like this:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;qvp://servername/url.qvw?tabname=2&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;and also please find the attached sample application as requested.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 19 Jul 2011 08:56:59 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308634#M113944</guid>
      <dc:creator />
      <dc:date>2011-07-19T08:56:59Z</dc:date>
    </item>
    <item>
      <title>Re: How to obtain the url string?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308635#M113945</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt; That worked. The secret is the qvp:// protocol. &lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I have made some tests with the ajax, using the select= syntax but it select the field (the box changes its color to a selected color) but it does not select the content I wanted. &lt;/P&gt;&lt;P&gt; Any idea on how ajax would work? How could I select a field´s value?&lt;/P&gt;&lt;P&gt;thanks again&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Tue, 19 Jul 2011 13:22:09 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308635#M113945</guid>
      <dc:creator />
      <dc:date>2011-07-19T13:22:09Z</dc:date>
    </item>
    <item>
      <title>Re: How to obtain the url string?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308636#M113946</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Sorry Macros still wont work properly or at all in Ajax. If you want you can first try in IE plug-in and let me know if you need further help on this.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;But Ajax with Macro sorry i cant help.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Cheers.&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 20 Jul 2011 03:05:06 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308636#M113946</guid>
      <dc:creator />
      <dc:date>2011-07-20T03:05:06Z</dc:date>
    </item>
    <item>
      <title>Re: How to obtain the url string?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308637#M113947</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;&lt;SPAN&gt;Thanks for the help BlackRock your solution answers my origonal question(&lt;/SPAN&gt;&lt;A class="jive-link-external-small" href="http://community.qlik.com/thread/30237"&gt;http://community.qlik.com/thread/30237&lt;/A&gt;&lt;SPAN&gt;) but I am using ajax and hoping to access the url string, does anyone have any ideas?&amp;nbsp; Is it even possible to get the url string? &lt;/SPAN&gt;&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 18 Aug 2011 16:38:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308637#M113947</guid>
      <dc:creator />
      <dc:date>2011-08-18T16:38:21Z</dc:date>
    </item>
    <item>
      <title>Re: How to obtain the url string?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308638#M113948</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi BlackRock,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;I have a situation where in i need to pass the Input Parameter from the URL (Query String) to the stored procedure and bind the dashboard.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Ex: www.google.com/ID=4&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;I am trying to access the above ID field in a variable and then pass to the Stored Procedure as&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;sql exec sproc $(ID);&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;I am facing issues to access the query string value and also to bind a variable to the stored procedure dynamically instead of declaring as $(ID)=1.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P style="background-color: #ffffff; color: #737373; font-family: Arial;"&gt;Please let me know if you find any solutions.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks,&lt;/P&gt;&lt;P&gt;Sai Krishna&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Wed, 26 Dec 2012 11:35:21 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308638#M113948</guid>
      <dc:creator />
      <dc:date>2012-12-26T11:35:21Z</dc:date>
    </item>
    <item>
      <title>Re: How to obtain the url string?</title>
      <link>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308639#M113949</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hi &lt;A _jive_internal="true" class="jiveTT-hover-user jive-username-link" href="https://community.qlik.com/people/blackrocks" id="jive-4056023881089677761500" style="background-color: #ffffff; font-size: 12px; color: #007fc0; font-weight: bold; font-family: Arial; text-align: center;"&gt;BlackRockS&lt;/A&gt;:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;When I use qvp://... to open the qvw, it will be give me a error massage,look like the following:&lt;/P&gt;&lt;P&gt;failed to open document&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;How can I resolve the problem?&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks/peach&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Thu, 06 Jun 2013 07:00:43 GMT</pubDate>
      <guid>https://community.qlik.com/t5/QlikView/How-to-obtain-the-url-string/m-p/308639#M113949</guid>
      <dc:creator />
      <dc:date>2013-06-06T07:00:43Z</dc:date>
    </item>
  </channel>
</rss>

