It is possible passing parameters from qv document to a url???

[#1]

Can anyone help me with this issue, i want to pass some paramenter to a url but it is possible, and if yes how can i do it??

Regards

Carlos

[#2 · Accepted solution]

Not sure this is what you mean:

You can construct an URL based on fields, e.g.

Expession: ='GoogleIt<url>http://www.google.be/search?q=' & YOURFIELD & ''

On the expressions tab: Representation: select "Link"

Greetings,

Piet

[#3]

Yes, it's possible. I've gotten it to work via a button on a form, where selection criteria gets passed.

The trick is the web app getting called MUST accept GET parameters, as QlikView will not do a POST.

-Kevin

[#4]

Here's a discussion that covers some of what you're looking for

http://community.qlik.com/forums/p/26820/102686.aspx#102686

Another example

http://community.qlik.com/forums/p/25304/96722.aspx#96722

[#5]

@Piet

I am trying to create a clickable link in a table as well...

I have selected Representation: "Link" - on the expressions tab:

But I have multiple query parameters and qlikview is encoding the ampersand...

I ENTER:
Expression: ='Click to View...' & '<url>https://www.mycompany.com/pl/mypage.bix?id1=OD38&id2=E8145815'

I GET IN BROWSER
https://www.mycompany.com/pl/mypage.bix?id1=OD38%26id2=E8145815

Then the webserver I am linking to throws an error.

(Obviously I will make the id's dynamic going forward but even this hardcoded version is not working for me.)

I've tried "&amp;" and "&&" and "%26" to pre-ecode the ampersand myself but no luck.

Any help is greatly appreciated.

[#6]

Hello,

your expression works without problem for me - maybe some 'regional setting' of Windows.

Maybe you can try using this:

='Click to View...' & '<url>https:

//www.mycompany.com/pl/mypage.bix?id1=OD38' & chr(38) & 'id2=E8145815'

Greetings,

Piet

[#7]

Thanks.

chr(38) gets converted as well.

I can tell this is happening in QlikView because it shows the URL encoded in the pop-up warning dialog before launching the browser.

Any hints on where to look for 'regional settings' (I'll also google QV forums now.

[#8]

WinXP > Control Panel > Regional and Language Options set to "English (united states)" seems pretty innocent.

[#9]

Ugh...

An "&" gets displayed fine in a Text Object... something about that link representation that is encoding this character.

If anyone has any ideas - please let me know!!!

[#10]

(Guessing, since I cannot reproduce the problem!)

Maybe some encoding parameter for User/QV/Doc...

Setting > Document Properties > Default export encoding > (I've got ANSI)

Settings > User Preferences > Export > Encoding > (ANSI)

...

Or:

If you download some QV from this forum, and try a link in that file, does that work (=doc issue) or not (=user or PC issue),

Piet