topic Automatically generated, predictable hyperlink to application selection state in QlikView

Automatically generated, predictable hyperlink to application selection state

justin_morley — Thu, 21 Nov 2013 10:29:23 GMT

Hi all,

Trawling threads in this forum about bookmarks, I'm beginning to suspect my requirement isn't possible.

I have an external tool, into which I want to include hyperlinks. These hyperlinks will take me to my QlikView application, but with a specific selection applied. Something like:

http://<qvserver>/<AccessPoint etc.>A1203

http://<qvserver>/<AccessPoint etc.>B1306

where the A1203 bit of the URL selects a given dimension say:

SelectionID

------------

A1201

A1202

A1203 <- This would be selected, and filtered on

B1301

B1302

Behaving like a restful service call for example.

I could probably set up bookmarks manually and provide a URL for each selection state, but this has to be automated, as it has to work without human intervention.

Is there anyway to generate bookmarks in script for each value in a given field for instance? The number of values in this field grows by ~300 every year.

Does anyone have any other suggestions to acheive the same thing?

Thanks in advance

Justin

Re: Automatically generated, predictable hyperlink to application selection state

justin_morley — Thu, 28 Nov 2013 12:04:51 GMT

Could anyone give me confirmation either way whether the above is possible?

Thanks,

Justin

Re: Automatically generated, predictable hyperlink to application selection state

jerrysvensson — Thu, 28 Nov 2013 14:03:26 GMT

The first one is possible

Create a box with the ID = StartSelection (doesn't matter what name), with field SelectionID.

Then:

http://<qvserver>/<AccessPoint etc.>&select=StartSelection,A1203

Re: Automatically generated, predictable hyperlink to application selection state

justin_morley — Thu, 28 Nov 2013 14:19:04 GMT

Hi Jerry,

Thanks very much for the reply. If that worked it would be amazing! Trying it in my system doesn't seem to do anything. Is that syntax definitely right? Is it definitely a comma between field and value? Is it expecting an Object ID, Object title, or actual dimnsion name? None of these worked when I tried them.

I can't find any documentation for this anywhere either

Cheers,

Justin

Re: Automatically generated, predictable hyperlink to application selection state

justin_morley — Thu, 28 Nov 2013 14:22:49 GMT

Actually, scratch my last mail, it works!!!! Thanks so much for this reply, this solves a massive problem for us and I'm very greatful for your support!

In answer to my own question above, the comma IS correct, and it accepts the object name