Solved: Re: How to copy the QS sheet from 1 QVF to another... - Qlik Community

paulyeo11 · ‎2016-09-07

Hi All

it there a faster way to copy 30 sheet of my project from one to another QVF ?

Now i need to copy one by one object into another one.

In QV i can select all chart and table and paste to new sheet.

Hope some one can advise me.

Paul

kaushiknsolanki · ‎2016-09-08

Hi,

If my understanding of your problem is right then here is the detail.

Consider that you have the Main QVF1 which has scripting and also 60 sheets.

Now you need same application but which shouldnt have Script but should have binary load.

So you need to copy the same QVF say it will be QVF2. Now here you will delete the entire script, so your visualization of 60 sheet remain same, but you will just add the Binary load statement which will load the data from QVF1.

Hope its clear.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

ishanbhatt · ‎2016-09-08

Hi Paul.

There is no any faster way to doing this.

Thanks,

Ishan

kaushiknsolanki · ‎2016-09-08

Hi,

If it is from one Qvf to another, then I feel the best option is you change the script part of the other Qvf, because that will be faster then coping the charts.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

paulyeo11 · ‎2016-09-08

Hi Kaushik

Binary 'lib://vFOLDER_/000_QVD_V7004.qvw'; // DOD full

In my QVF file , i only have above line of script. Can you share with me how to change , so that some of the sheet will move to another QVF ?

Paul

kaushiknsolanki · ‎2016-09-08

Can you tell me how many sheet you have in QVF1 and in QVF2.

Also is there any change in script. or it is just a Binary load?

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

paulyeo11 · ‎2016-09-08

I have 60 sheet in one QVF , Yes only change binary load.

kaushiknsolanki · ‎2016-09-08

Hi,

then you can copy the original QVF and just remove the entire script and put one statement which is your binary load in new QVF.

You dont need to copy anything else.

Hope you got the idea.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

paulyeo11 · ‎2016-09-08

Hi Kau

I am not clear what you mean , can you pls give me detail info.

kaushiknsolanki · ‎2016-09-08

Hi,

If my understanding of your problem is right then here is the detail.

Consider that you have the Main QVF1 which has scripting and also 60 sheets.

Now you need same application but which shouldnt have Script but should have binary load.

So you need to copy the same QVF say it will be QVF2. Now here you will delete the entire script, so your visualization of 60 sheet remain same, but you will just add the Binary load statement which will load the data from QVF1.

Hope its clear.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

paulyeo11 · ‎2016-09-08

Hi Kau

https://community.qlik.com/thread/231901

After reading on your detail explanation . May I know will it solve my problem above link ?

Paul

How to copy the QS sheet from 1 QVF to another new QVF ?