topic Re: How to open new document..? in QlikView

How to open new document..?

Nagaraju_KCS — Mon, 10 Mar 2014 15:38:35 GMT

Hi All,

How to open a new qlikview document on change of values in the variable?

suppose i have pivot table when i am click particular cell i want show related data in the new Qlikview Document...

Ex: My chart

category Material Count(material)

A A001 50

B B001 10

suppose if iam click 50 i want to show 50 records in new Qlikview document

is it Possible..?

PFA,

Re: How to open new document..?

Nagaraju_KCS — Mon, 10 Mar 2014 16:18:51 GMT

Please anyone can help me.............

Re: How to open new document..?

giakoum — Mon, 10 Mar 2014 16:20:12 GMT

This is called document chaining. Look it up in the Qv manual.

see attached example or following video :

Passing Parameters in a URL and Document Chaining - YouTube

Re: How to open new document..?

Nagaraju_KCS — Mon, 10 Mar 2014 16:28:18 GMT

HI Loannis,

I got one example.. but this is button level..

i want chart level.. is it possible in chart level?

How to open QV application in new window using macro?

Re: How to open new document..?

giakoum — Tue, 11 Mar 2014 07:22:23 GMT

Chart level meaning? Clicking a value on a cell and open a document based on that?

Re: How to open new document..?

ashwanin — Tue, 11 Mar 2014 07:28:06 GMT

New Document ?

Re: How to open new document..?

Nagaraju_KCS — Tue, 11 Mar 2014 13:55:59 GMT

Hi Ashwani,

Yes, i want to open in new Document..

New Document means i have 2 qvw files (Test.qvw and Test1.qvw)

Suppose i have a Pivot chart in Test.qvw files

Ex: My chart

category Material Count(material)

A A001 50

B B001 10

If i am click 50 i want to show 50 records in Test1.qvw file

Hope you Understand...

Re: How to open new document..?

sunilkumarqv — Tue, 11 Mar 2014 14:00:22 GMT

try like these modify that into your functionality

Re: How to open new document..?

Nagaraju_KCS — Tue, 11 Mar 2014 15:19:33 GMT

Yes Loannis....

is it possible..?

Re: How to open new document..?

giakoum — Wed, 12 Mar 2014 09:58:09 GMT

Yes, maybe, if we create a hyperlink on every row, and the user clicks on the hyperlink to open a new Qv document. have not tried it but should work. Do you have two sample applications?

Re: Re: How to open new document..?

Nagaraju_KCS — Wed, 12 Mar 2014 13:22:05 GMT

Hi Loannis,

PFA,

Re: How to open new document..?

giakoum — Thu, 13 Mar 2014 16:39:16 GMT

So I think this must be it :

Create a new expression in your chart with Representation = link :

and add the following as expression :

='Link' & '<url>' &

'http://<YourServer>/QvAJAXZfc/opendoc.htm?document=<YourDocument>.qvw' &

'&sheet=SH04&select=LB34,(201401|201403)&select=LB42,(Server)&select=LB36,(Error)'

the sheet variable specifies a certain sheet to open (by sheetID)

the select variable specifies a list box and certain values to be selected from the list box i.e. select=LB34,(201401|201403) meaning that from list box with ID LB34 select values 201401 and 201403. You can have as many select variables as selections you need to make, but need to create list boxes in the new application for every selection needed. I have not tried it with objects other than list boxes. You can have a hidden sheet with the list boxes so that you do not mess up your layout.

Since this is on row level in chart, you can use your actual values in the link instead of hard coding them like I did. This way I believe you can achieve what your are looking for.

Hope this helps!