topic Re: Hyperlink coming from db in QlikView

Hyperlink coming from db

ashmitp869 — Fri, 20 Aug 2021 02:03:51 GMT

Hi there,

Is there any way to make the Open URL Action to be dynamic ?

i.e the URL will come from db , and The value can be use in URL to open the hyperlink.

Thanks

Re: Hyperlink coming from db

Gysbert_Wassenaar — Fri, 20 Aug 2021 10:45:53 GMT

No, I don't think so. Variables don't work. You could try a macro. Perhaps using a straight table is an option. You can add hyperlinks to straight tables.

Re: Hyperlink coming from db

stevejoyce — Fri, 20 Aug 2021 12:44:54 GMT

@Gysbert_Wassenaar unless i am interpreting differently, you can have a variable in the URL (indicated by ellipses to accept function).

create a variable called vUrl defined as: www.google.com

The open URL can open ='$(vUrl)'

So with this yes you should be able to store your url from db into a variable. i'm sure you can have this evaluated in the context of your selections if you want filters to determine different URLs with a calculation.

Re: Hyperlink coming from db

Gysbert_Wassenaar — Mon, 23 Aug 2021 13:56:32 GMT

@stevejoyce: you're right. I made a typo in my test. It works as you say.