topic Re: Pass the selection and apply that selection in second file in QlikView

Pass the selection and apply that selection in second file

jagannalla — Fri, 01 Feb 2013 14:30:56 GMT

Hello,

I've a two listboxes in one qlikview file. Now I'll select 2 or more values from each listbox.

I've another list box which gives the information of all qlikview file names which is available along with this file.

Now I'll choose my own file name.

After that when I click on the button it needs to open the respective file which i choose from the listbox. Once it is opened the selection which I made for two fields needs to apply in that file. All files will hold same fields.

Note : It needs to work at access point (web view)

Thanks,

Jagan

Re: Pass the selection and apply that selection in second file

Fri, 01 Feb 2013 14:41:04 GMT

This is call "Document Chaining", and you can do it with a QlikView standard action, from a button for example. There is an option to pass the filters to the second document.

Re: Pass the selection and apply that selection in second file

jagannalla — Fri, 01 Feb 2013 14:52:17 GMT

Can you please share any code with example..

Re: Pass the selection and apply that selection in second file

jagan — Fri, 01 Feb 2013 15:26:26 GMT

Hi,

Please find attached files for solution. It is working in QV Desktop, I am not sure about this in server.

Regards,

Jagan.

Re: Pass the selection and apply that selection in second file

jagannalla — Fri, 01 Feb 2013 15:43:19 GMT

It is working at access point also. But I've one question, what is the use of "Apply state on top of current" ?

If i check this option I'm not able to see my result.

Re: Pass the selection and apply that selection in second file

Fri, 01 Feb 2013 18:35:20 GMT

As you can see in the QlikView help:

Mark Apply state on top of current to retain the second document’s selections and apply the original document’s selections on top of them.

Re: Pass the selection and apply that selection in second file

jagannalla — Thu, 25 Apr 2013 09:01:22 GMT

Juan,

"Document Chaining" concept helped me a lot, but I'm facing the little bit problem. To know about Document Chaining I had gone through the below link.

http://community.qlik.com/message/317697

I'm trying below functionality but it is not working. Can you help on this.

In second file I've a field with name Product the values of product is A, A1, A2, A21. When I tried the URL with suffix as

& select=LB02,A1,A2

The result it shows me at access point, Product with values A1,A2,A21. I didn't specified A21 in URL but still it shows me the selection in the file.

How can I overcome this.

Can you help on this.