topic Opening Document on Server by URL: How to pass a parameter? in QlikView

Opening Document on Server by URL: How to pass a parameter?

chriscammers — Mon, 26 Jan 2026 18:19:17 GMT

I'm working with QVS 9 running the default Qlikview web services.(Not IIS)

I would like to open a QVW using a url but I want to pass a parameter from the URL to a variable in the document. Later I will use the value of this variable to make a selection but for now I'm happy just to show it on the screen.

I've tried adding a parameter to the link used by the Access point to open the document but this is not working. The document opens but the parameter does not seem to be applied.

http://myserver/QvAJAXZfc/AccessPoint.aspx?open=&id=QVS@myserver|mydoc.qvw&client=Ajax&UserParam=123

Am I approaching this the right way or should I be trying something else??

Thanks

Opening Document on Server by URL: How to pass a parameter?

biester — Tue, 29 Sep 2009 00:22:08 GMT

I don't think that this is possible from Ajax (you can pass a parameter - or better a parameter which passes a variable - when batch reloading) - anyone correct me if I'm wrong. What are you trying to achieve? What should the parameter do?

Rgds,
Joachim

Opening Document on Server by URL: How to pass a parameter?

chriscammers — Tue, 29 Sep 2009 00:25:34 GMT

I want to open the document and for now just show the value for the variable that I am trying to set with the URL parameter. If I get the value into a variable I can force the selection within a document. At the moment I would perfer the ajax client but any web based client would be OK.

Opening Document on Server by URL: How to pass a parameter?

biester — Tue, 29 Sep 2009 11:48:56 GMT

As said I'm afraid you can't hand a parameter over to AJAX. Of what kind IS the variable? Perhaps QlikView can automatically supply it, calculat it (OSUser, Systemdate or whatever) - or do you want to set the variable randomly, e.g. (slightly exaggerated) "Today I feel like having fish and chips for breakfest, and my users only may select China and France in my application" ? IM' afraid if the latter applies, you'll have to set the variable yourself every day resp. by automation.

Rgds,
Joachim

Opening Document on Server by URL: How to pass a parameter?

chriscammers — Tue, 29 Sep 2009 19:16:00 GMT

OK, Here's the full background,

I am attempting to integrate a qvw with Microsoft CRM 4. On the account form I added an iframe which will display a Qlikview dashboard on the server but I don't want to force the reload every time a user opens the qvw since this will probably cause problems for the CRM application. So I wanted to pass the account id from the account form to the QVW using the resulting variable to force a selection on the dashboard. This way the user would see a dashboard specific to that account.

In addition I'd like to do the same on other forms for entities like product.

Some of this can be done using section access based on the user's identity but selecting a specific product or account seems to be out of reach.

Do you think I have to write some special wrapper that will set the value of the selection before presenting to the user??

Thanks

Chris

Opening Document on Server by URL: How to pass a parameter?

biester — Wed, 30 Sep 2009 01:26:18 GMT

Well, I doubt whether this is possible. I think what cannot be achieved via section access etc. (hence values that QlikView more or less can retrieve by itself) cannot be achieved from "outside" by handing a parameter ... I have only a very vague idea of writing some sort of "cookie" which could be read by an OnOpen macro, but I can hardly judge whether resp under what circumstances this is going to work with Ajax. Perhaps it's worth a try ... A sort of wrapper? Maybe a good idea, though I haven't the slightest imagination of how this could work - but perhaps it's also worth thinking about that. Sorry for not being able to help for now, but perhaps someone else has already had similar requirements and a solution ..

Rgds,
Joachim

Opening Document on Server by URL: How to pass a parameter?

Sun, 08 Nov 2009 12:14:54 GMT

Were you able to open a qvw file and passed the required parameters via a URL by any chance ?

Opening Document on Server by URL: How to pass a parameter?

Wed, 11 Nov 2009 08:10:14 GMT

Hello,

Is there anyone who was able to successfully open a qlikview document and passing a parameter via URL ?

Appreciate your feedback.

Opening Document on Server by URL: How to pass a parameter?

Thu, 22 Apr 2010 17:08:59 GMT

Yes, I was!! 🙂

you can do something like this:

http://localhost/qvajaxzfc/opendoc.htm?document=Validation/AgentStateSA.qvw&userid=105953&"&"&password=ABC123

I understand the only parameters you can send into a qv document are the username and password. these get captured inside of the document with a function such as =QVuser() -for the user, etc...

you can also use filters on the url and the document will filter based on those

is this what you are trying to accomplish?

thanks,

Opening Document on Server by URL: How to pass a parameter?

Thu, 22 Apr 2010 17:13:33 GMT

One more note..

depending on your security settings, for instance if you are using custom security (DMS), you will need to pass a ticket.

if you wish to open the report on a different page, you can do something like this:

window.open("http://" + escape(gsServerName) + "/qvAJAXzfc/opendoc.htm?document=" + escape(gsFileName) + "&userid=" + iv_user + "&password=" + pswd + "&ticket=" + escape(ticket), "_blank");

(or remove userid and password if you are not using section access.)

if you wish to add the report dynamically to a page, you can do the following:

var src = "http://localhost/QvAJAXZfc/opendoc.htm?document=Localization_sample.qvw" + "&userid=" + iv_user + "&ticket=" + escape (ticket);
var divsrc = "<center><iframe src=" + src + " width='1020px' height='800px' frameborder='0'></iframe>";
divsrc = divsrc + "</center>";

div1.innerHTML = divsrc;

Opening Document on Server by URL: How to pass a parameter?

chriscammers — Thu, 22 Apr 2010 17:17:20 GMT

Yeah, passing the userid and password is good but in CRM the user has access to many accounts so what I would like is the dashboard to make the default selection based on the account that the user was viewing in CRM. Then if the user wants to see the dashboard with all of his/her accounts they can just clear the account selection. The cool part is that I was trying to integrate it into the account form as an iFrame so it is important to show only the current account.

Opening Document on Server by URL: How to pass a parameter?

Thu, 20 May 2010 20:58:02 GMT

Hi,

I've got a similar problem with SuperOffice. Did you ever solve the problem?

Opening Document on Server by URL: How to pass a parameter?

chriscammers — Thu, 20 May 2010 21:15:46 GMT

Sorry, not yet. I've put it in as a suggestion for enhancement.

Opening Document on Server by URL: How to pass a parameter?

Fri, 21 May 2010 10:16:38 GMT

I have heard the the following works (and appears to using QlikView's demos) but I have not yet got it to work in my own environment:

Selecting a single item. Must use the List Box ID followed by a comma and then the search term:
http://localhost/QvAJAXZfc/opendoc.htm?document=demo.qvw@select =LB01,Gloves

Selecting more than one item, separate by commas, also illustrates that you must use %20 to replace spaces in search terms:
http://localhost/QvAJAXZfc/opendoc.htm?document=demo.qvw&select=LB03,Bike%20Stands,Gloves

This is also demonstrated in the following post:
http://community.qlik.com/forums/p/24531/101135.aspx#101135

Let me know if you manage to get this working.

Opening Document on Server by URL: How to pass a parameter?

ashfaq_haseeb — Mon, 07 Mar 2011 15:20:33 GMT

had someone successful?

Opening Document on Server by URL: How to pass a parameter?

Sun, 01 May 2011 04:15:33 GMT

business_support gives a good idea!

Opening Document on Server by URL: How to pass a parameter?

Tue, 04 Oct 2011 12:42:58 GMT

yes, startup selections in ajax worked for me. The following url makes some startup selecitons in existing listboxes LB138 and LB139:

http://myQVServerName/QvAJAXZfc/opendoc.htm?document=MyReportName.qvw&select=LB139,*10*&select=LB138,Sweden

Opening Document on Server by URL: How to pass a parameter?

Fri, 07 Oct 2011 07:35:47 GMT

Hi,

I tried this one

http://ing15/QvAJAXZfc/AccessPoint.aspx?open=&id=QVS@ing15%7CAktiviteter.qvw&client=Ajax@select=TB02,Kanvas

Do you have any idea why it doesn't work?

Opening Document on Server by URL: How to pass a parameter?

Fri, 07 Oct 2011 16:03:37 GMT

You need to use an '&' to separate name value pairs so in your case it will be:

http://ing15/QvAJAXZfc/AccessPoint.aspx?open=&id=QVS@ing15%7CAktiviteter.qvw&client=Ajax&select=TB02,Kanvas

Opening Document on Server by URL: How to pass a parameter?

Tue, 22 Nov 2011 04:47:36 GMT

Same question,

had someone successful?