topic Using variables in the URL expressions (something with the equal ("=") signs in the variables. in QlikView

Using variables in the URL expressions (something with the equal ("=") signs in the variables.

manoranjan — Fri, 11 May 2012 07:29:21 GMT

I am trying to create a Straight table with URL links. URL is loaded from Excel sheet, represented by a field in a table. Trick here is the URL's will have input parameters (query string) and I am handling this as part of the Expressions. Replacing the input param indicators (param1 = $p1$, param2 = $p2$) in the URL string with the actual values from the Selections made by user.

This works fine when I select any one of the rows in ths straight table. But when i directly click on the link, the input parameters are not gettig rendered inside the URL. Please find attached the sample application to replicate this problem.

I removed the "=" signs in the variables, it works fine, except the Selections are not coming into the URL

P,S: do not get carried away by the "Left" / "Mid" / "Index" functions I have used. It is tested and no issues with that.

Please help

Using variables in the URL expressions (something with the equal ("=") signs in the variables.

manoranjan — Fri, 11 May 2012 12:17:54 GMT

In my Table the URL is given as

www.xe.com?Curr=$p1$&Country=$p2$

Note the $p1$ in the string will be replaced by the Selected values in the Application. Which one of the Selected fields to use, is also given as part of the input Excel feed.

Everything works fine, when i select a row in the table, otherwise it is not.

Someone kindly help

- Mano

Re: Using variables in the URL expressions (something with the equal ("=") signs in the variables.

kaushiknsolanki — Sun, 13 May 2012 14:59:59 GMT

HI,

Find below the solution.

Hope this will help you.

Regards,

Kaushik Solanki