Open URL from within List Box of Qlikview document

Fri, 20 Nov 2020 18:02:30 GMT

So say you pulled this data into QlikView and were displaying it in a list box. Can the user click the url displayed and a separate window opens with browser and url? It should open to a disclaimer page, you click accept and then it takes you to system information page for the system id (ea id) included in the url. Business Objects has some settings to read a cell as html…or could I look at something like that too and do something like <a href="https://eair.dhs.gov/apex/f?p=105:130:0:::RP,130:P130_SYSTEM_ID:9287" target="_blank">EAIR-9287</a> if we need to.

The url usually has a session id where the 0 is, but I read that we can substitute 0 so the url or bookmark or whatever can be used for apex url’s.

Thank you for your help.

SYSTEM	EA_ID	URL
AFM1	5684	https://eair.dhs.gov/apex/f?p=105:130:0:::RP,130:P130_SYSTEM_ID:5684
AWSBETA	5462	https://eair.dhs.gov/apex/f?p=105:130:0:::RP,130:P130_SYSTEM_ID:5462
AWSBETA	8418	https://eair.dhs.gov/apex/f?p=105:130:0:::RP,130:P130_SYSTEM_ID:8418
AWSBETA	9520	https://eair.dhs.gov/apex/f?p=105:130:0:::RP,130:P130_SYSTEM_ID:9520
DRMM.US.ORACLE.COM	1520	https://eair.dhs.gov/apex/f?p=105:130:0:::RP,130:P130_SYSTEM_ID:1520

Re: Open URL from within List Box of Qlikview document

Gysbert_Wassenaar — Fri, 16 Jan 2015 10:21:32 GMT

You can't use a list box, but you can use a straight table object. Set the expression type to Link. Use as expression something like =SYSTEM & '<URL>https://........_ID:'& EA_ID.

Re: Open URL from within List Box of Qlikview document

fkeuroglian — Fri, 16 Jan 2015 12:27:42 GMT

See this example

Good luck

Fernando

topic Re: Open URL from within List Box of Qlikview document in QlikView

Open URL from within List Box of Qlikview document

Re: Open URL from within List Box of Qlikview document

Re: Open URL from within List Box of Qlikview document