Passing Parameters in a URL and Document Chaining

[Josh_Good]

This videos describes how to pass parameters in a URL and how to leverage this techinque to chain documents when using AJAX.

The genral syntax is as follows:

http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=LB01,Value

It is also possible to us a similar technique to go directly to a specific sheet within a document using the sheet parameter.

e.g. http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&sheet=SH01

http://youtu.be/ESSvm_xMTlE

[amien]

Thanks!

[nayrlloyd]

Hi Josh.  Thanks for the vid!

My question is, can you reference the selections from a straight table in the URL?  My goal is to doc chain from a Summary QVW to a Detail QVW.  The screenshot below shows my Summary QVW table.  I would like for the user to be able to click on 'F0911 Detail' on the 'DRY PARTITION' row for example and pass parameters for GLAccount and Subledger.

I was hoping to be able to use something like this:  ='F0911 Detail'&'<url>'&vF0911_URL&'&select=CH40,GLAccount, Subledger' as the Expression in the 'Detail' column, but it's not working.  It seems like all of the doc chaining examples that I've found online use list boxes in the URL and none use charts.  So I'm wondering if it's possible?

Any ideas would be welcome.  Thanks.

[Josh_Good]

Hi Ryan,

Yes that should be possible.  If you use the same syntax as described in the video (and have listboxs for GLAccount and Subledger), then you should be able to use the Subledger and GL field in the expression and it will dynamically be correct for each link in the table.

So you will end up with an expression something like:

='Detail<UR>http://myserver/QvAJAZfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=LB01,' & [GLAccount] & '&Select=LB02,' & [Subledger]

Hope that helps!

Josh

[#5]

Dear Josh,

I have another Problem with passing paramenters via URL. Everything is working fine.

But if somebody opens an application via URL and is Setting another filter, I have the Problem if this Person is reopening the application via URL, the filter which was set, is setted again.

Is there a Workaround to clear the setted Detail filter?

Thanks!

Btobias

[Josh_Good]

It sounds like their session is still active so all other selections are still active as well.  If you are using an URL then the only way I can think of is to specifically code the other fields as no selection in the URL.  This would be problematic if there are more than a few fields that could be selected.  You may want to investigate an alternate approach such as having the user select down to one record and then having a button appear that opens the next qvw.  This button could use the "Open QlikView Document" action described above.

[NareshGuntur]

Hi Josh,

I have done the same thing which you have explained above. It's working fine at the desktop level. But do you think that this works the same way in Access Point as well? I have given the document name which is in the same folder as of the current document. But it is unable to open the document.

I can use the "open url" but I can't restrict the user to select only a particular field. There are lot of fields which user may select some of them.

Cheers,

Naresh

[Josh_Good]

HI Naresh,

If you want to pass paramaters between documents on a server you should us either 'Open URL' or 'Open QlikView Document' as your action.  'Open URL' will allow you to pass only specificed paramaters. 'Open QlikView Document' will allow you to pass all match fields (you need to hit check pass paramaters check box)

-Josh

[#9]

Hi Folks,

I have a List BOX where values are W 1, W 2 and W 3 and so on.... If I pass W 2 in the url it does not work because of the spaces. However W1, W2, W3... it works as it does not have a space.

How can we handle this space issue?

Thank you.

[Josh_Good]

Hi

In your expression that generates the URL use the Replace function to replace spaces with a single character wildcard '?'.

So your expression will be something like this:

='http://myserver//QvAJAXZfc/opendoc.htm?document=DocumentName.qvw&host=Local&select=LB01,' & Replace(FieldName, ' ', '?')

-Josh

[#11]

if i want for fields in specific table then how can i write condition in open new document (insted of url)