Button object to Pass URL

[qlik_venu]

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&met...

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

[Anonymous]

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

[qlik_venu]

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

[Anonymous · Accepted solution]

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.

[#5]

Hi Venu,

Kindly check this attached sample application

Regards,

Sampath Kumar . G

[#6]

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...' & 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!!!