topic Button object to Pass URL in QlikView

Button object to Pass URL

qlik_venu — Sat, 12 Mar 2011 18:34:37 GMT

Hi All,

I have a button object, which when selected has to pass a URL.

SO i have used the "Action" property of the button object and have the "Open URL".

In my URL link, I also need to pass the current field selections of a Country field, which must be added to the end of the URL.

The URL is,

http://apps/c8/cgi-bin/cognosisapi.dll?b_action=xts.run&m=portal/launch.xts&ui.tool=CognosViewer&method=execute&ui.object=/content/report[@name='ReportName']&ui.action=run&b_action=cognosViewer&run.outputFormat=HTML&run.prompt=false&p_country_prompt=Value1

The Value1 at the end of the URL above should actually pass the getfieldselections(Country).

I tried defining a Variable1 as concat(URL, getfieldselections(Country)). but the expression didnt work.

Please let me know how we can do this URL + Value1 on a button to 'Open URL'

Thanks,

Venu

Button object to Pass URL

Anonymous — Sat, 12 Mar 2011 18:58:54 GMT

If it is always only one country, it will be
=URL & Country
or
=URL & only(Country)

Button object to Pass URL

qlik_venu — Sun, 13 Mar 2011 08:19:50 GMT

hi,

Thanks.

When i use a URL like this :

:http://apps/http://am-usa01-c8bi01.nam.merial.net/c8/cgi-bin/cognosisapi.dll?b_action=xts.run&method=execute&ui.object=/content/report[@name='Report test1']

So I get error in the exprsesion, as the URL already has a single quote with in it. ( ' ).

This is interfeing with the formula.

Can you please let me know how do I inform Qlikview not to consider any ( ' ) quotes which comes within a particluar String. (URL).

Thanks ,

Venu

Button object to Pass URL

Anonymous — Mon, 14 Mar 2011 23:59:34 GMT

Venu,
Not quite clear to me, sorry. Usually I test the quality of URL by creating the same expression in a text box. From there, you can copy text to clipboard, and paste into a browser - easy to see where the problem is.

Button object to Pass URL

Tue, 15 Mar 2011 04:55:03 GMT

Hi Venu,

Kindly check this attached sample application

Regards,

Sampath Kumar . G

Button object to Pass URL

Mon, 31 Oct 2011 22:29:45 GMT

Hi there, I'm facing quite the same problem. In my case there is a single quotes in the middle of the url, like this:

'https://xxxxxxxxxxwebclient.xxxxxx.com/arsys/forms/xxxxxxxxx/HPD%3AHelp+Desk/Default+User+View/?qual='1000000161'%3D%22' & only(CaseNumber) & '%22'

When I try to use the hyperlink Qlik is replacing the sigle quotes with the %27 (which is the single quotes I know!) but the url falls in a error because it couldn't found the proper record.

So how can I call an url like this? I already try to use chr(39) instead the single quotes but the same result.

Thanks!!!