how can i use field name in another qv document??

[#1]

Hi all ,

i have created sample.qvw with empno(1-100),sal,deptno.

also i have created another test.qvw with empnum(1-100000),sal,deptno,ename.

i have created button in sample.qvw when i click on that it will open test.qvw but i need to use empno from sampl.qvw in test.qvw.

how can i use empno from sample.qvw with out loading any data in test.qvw and also if i make stright table based on empno in test.qvw it shoud show related sal,ename in test stright table.

how can i chain to empno from sample.qvw  when i make any selections in sample then it should be reflected to test.qvw(data for empno is availbale in test.qvw but empno range is different) ?

please suggest me

[ashfaq_haseeb · Accepted solution]

Hi,

Make sure you select transfer state.

have a look at attached image.

Regards

ASHFAQ

[#3]

Hi,

Better way would be to make a qvd using STORE and then use it in another qlikview file.

Hope this helps

[MayilVahanan]

Hi

Try like this

If both documents are into the same folder just write into the document name textbox the name of the document including the qvw extension. If you want to keep the selections from the first document  remember two facts:

• Fields must have the same name into both documents
• "On Open document/sheet" triggers could modify the selections
• Transfer state must select in the Action.

PFA