topic Re: How to pass a variable for field selection in a URL? in QlikView

How to pass a variable for field selection in a URL?

Tue, 21 Jun 2011 00:40:23 GMT

I am struggling to pass a variable in a URL. I would like a value in the url to select the value in a field.

Here is an example URL: http://qlikviewdev/QvAJAXZfc/opendoc.htm?document=public/report.qvw&host=QVS@svr&partnbr=1234

In my script I set two variables:

SET partnum=0;

SET partnbr=0;

I setup a simple macro that I hoped would get the partnbr from the url. Here is the macro VB script that runs:

sub test

set partnum = ActiveDocument.GetVariable("partnbr")

ActiveDocument.Fields("PART_NBR").Select partnum.GetContent.String

End Sub

I run this macro on a button press, unfortuanitally it does not work. Can anyone help explain what I am missing, or how I should be going about this.

Thanks!

How to pass a variable for field selection in a URL?

Tue, 21 Jun 2011 20:26:38 GMT

I have also attempted to accomplish this through Jscript which has also failed. Example functions:

//this function grabs the params from the url

function gup( name )

{

name = name.replace(/[\[]/,"\\\[").replace(/[\]]/,"\\\]");

var regexS = "[\\?&]"+name+"=([^&#]*)";

var regex = new RegExp( regexS );

try{

var results = regex.exec( window.location.href );

}

catch(err)

{

return err;

}

if( results == null )

return "Got Nothing From Params";

else

return results[1];

}

Whenever I run this I get an error about the window object... can the window.location object not be used? Anyone have any success getting at url params from JScript?

Re: How to pass a variable for field selection in a URL?

Miguel_Angel_Baeyens — Tue, 21 Jun 2011 21:02:53 GMT

Hello,

Although it's not the most elegant solution, and its useness will depend on whether you know the name of the field you want to extract from the URL, you can use something like the following in your script:

Set vURL = http://qlikviewdev/QvAJAXZfc/opendoc.htm?document=public/report.qvw&host=QVS@svr&partnbr=1234;
Set eXtract = TextBetween($1, $2, '');
Let vPartnbr = $(eXtract('$(vURL)', 'partnbr='));

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

Re: How to pass a variable for field selection in a URL?

Tue, 21 Jun 2011 21:28:13 GMT

Well my current issue is getting to that url string. I am basically looking for a way to access it, and have not been able to yet. Once I have that string, parsing it shouldnt be too much of an issue. Anyone know how to get it?

Re: How to pass a variable for field selection in a URL?

Tue, 21 Jun 2011 22:21:10 GMT

I have restructured my discussion here: http://community.qlik.com/thread/30326

Re: How to pass a variable for field selection in a URL?

Wed, 20 Jul 2011 03:20:02 GMT

Hi,

Anybody who ended up at this thread pls refer to my comments @ http://community.qlik.com/message/133891#133891

Cheers.