Can I open a second web page using a value returned from the first?
Hi. I currently have a Qlikview table object that includes a dimension that has an associated hyperlink - say we call that dimension "VisibleRef". The url for the hyperlink looks something like "http://app.acme.com/search1.asp?RefA="&VisibleRef. When clicked, the web page opens in the browser and displayed in the url of the browser is a new, 'hidden' ID (8 chars) called say 'HiddenRef' - so the url looks something like "http://app.acme.com/display1.asp?RefB=12345678". What I want to be able to do is grab the value of HiddenRef from the url ('12345678' in this case) and use it to open a final url such as "http://app.acme.com/Edit.asp?RefB="&HiddenRef. So, to summarise what I would like happen is:
Click on hyperlinked dimension "VisibleRef", open webpage in background, grab the value of the "HiddenRef" then open a foreground web browser page using the value of "HiddenRef" in a new url.
Unfortunately, I don't have control of the web server. My problem is the reports I pull off the server use the primary (visible) ref, but the hyperlink that uses the visible ref opens a view-only page for the item. I need to open the edit page for the item, the url of which uses the the secondary (hidden) ref - which gets displayed in the address bar when you open the first hyperlink. If when clicked Qlikview could open the search url in the background, wait for the redirect to the view page, then grab the secondary ref that appears in the view page url and use it to open the edit page in a full browser window, it would be ideal.