topic Re: Open a Document specific sheet through URL Parameter in QlikView

Open a Document specific sheet through URL Parameter

stevegimbrollmt — Thu, 03 Apr 2014 13:39:30 GMT

HI,

I am trying to use the url to open specific sheets based on the link, Is there a parameter for sheet?

Currently I am doing something like this

http://celont98.scee.net/QvAJAXZfc/AccessPoint.aspx?open=&id=QVS@celont98.internal.scee.net%7Cosg/Digital%20Report%20Automation.qvw&//celont98.scee.net/QvAJAXZfc/AccessPoint.aspx?open=&id=QVS@celont98.internal.scee.net%7Cosg/Digital%20Report%20Automation.qvw&sheet=SH22&client=Plugin

I would want to use this link and change the sheet object as a parameter

Is it possible?

Thanks!

Steve

Re: Open a Document specific sheet through URL Parameter

maxgro — Thu, 03 Apr 2014 22:58:21 GMT

Ajax example

IPofYourServer/QvAJAXZfc/opendoc.htm?document=demo/doc1.qvw&sheet=SH29&select=LB395,H783&select=LB394,U-1-10-,U-1- 29-,U-2-510-

IPofYourServer IP address (or name)

document qlik doc

sheet sheet

select listbox and selected values

add http...... before IPofYourServer

Re: Open a Document specific sheet through URL Parameter

stevegimbrollmt — Fri, 04 Apr 2014 10:48:15 GMT

Thanks for the suggestion, I have tried added the sheet=SH## but it still does not go to the sheet I want it. its like there is something not recognised

Re: Open a Document specific sheet through URL Parameter

maxgro — Fri, 04 Apr 2014 12:33:10 GMT

Passing Parameters in a URL and Document Chaining

Re: Open a Document specific sheet through URL Parameter

stevegimbrollmt — Tue, 08 Apr 2014 09:31:24 GMT

still working on this. not sure how i can direct a specific sheet. Maybe using macros.. need to do more reading

thanks Massimo Grossi