I need to automatically make a selection when a qlikview document (hosted in IIS) is opened based on an external value.
To explain: I've got a table in QlikView called bookings, with a booking_id column. Now I want to pass the booking_id to the document (hosted in IIS) in the url, read it from the querystring and set a variable, and use section access to make the selection. I implemented the bit where I set up section access based on the value of a variable, and it works fine. All I need for this to work is to be able to set the value of the variable to the booking_id value in the query string.
Is there a way to do this? Have anyone done this before? (I have searched in the community and other blogs but can't find the solution)
I have tried it with a vbscript makro, but get an 'Request' object is Null error and with javascript I get a 'window' is not defined error within the Qlikview edit module dialogue.
