How to open new document..?

[qv_testing]

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,

[qv_testing]

Hi Loannis,

PFA,

[giakoum]

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!