topic Re: Clubbing apps without soure in QlikView

Clubbing apps without soure

Thu, 04 Jul 2013 10:58:24 GMT

Hi Experts,

I have a requirement.

Assume that there are 3 qvws. Now I want to club all into one application. So finally I want to have one qvw application.

From binary load will get only application right. So advice me how to load in case of no source.

Thanks

Suneela

Re: Clubbing apps without soure

Or — Thu, 04 Jul 2013 11:03:59 GMT

If you can access the source QVWs, you can throw each individual table (from all three) into a QVD and load the QVDs into a fresh QVW - but odds are you'll need to change the data model significantly to make it work, unless your three original models were built with this in mind.

If you can't access the source QVWs, I think you're pretty much out of luck.

Re: Clubbing apps without soure

Thu, 04 Jul 2013 11:07:38 GMT

You can do one by one only.. Using binary load..

App2 = App1 + App2

App3 = App2+App3..

Karthik

Re: Clubbing apps without soure

Thu, 04 Jul 2013 11:09:12 GMT

Hi,

Thanks for your reply.

But in that case, load will get fails right. Because I dont have source with me. So not possible to load and save it in qvd.

Re: Clubbing apps without soure

Thu, 04 Jul 2013 11:13:05 GMT

Here when we load app2 it will again will get fail. But we can save it. Anyway once after saving and fetching we need to load in new qvw. Now it will again fails since the qvw is just saved and not loaded. If we load then only data will save in memory.

I tried this method , but it did'nt work. Please help me in any alternative

Thanks

Re: Clubbing apps without soure

Thu, 04 Jul 2013 11:15:09 GMT

Do you want to do this as one time activity? or regularly?

Re: Clubbing apps without soure

Thu, 04 Jul 2013 11:16:29 GMT

one time

Re: Clubbing apps without soure

Thu, 04 Jul 2013 11:24:42 GMT

Create new qvw using binary load of first qvw...

then you can store any table as .qvd (using regular "Store tablename into table.qvd")

like this you can load for all 3 qvw..

Finally you can create new application based on these qvd. You can keep these qvd like history data..

Karthik

Re: Clubbing apps without soure

Thu, 04 Jul 2013 11:29:59 GMT

Thanks for the reply. I will work it and hope it looks correct. Thanks

Re: Clubbing apps without soure

Thu, 04 Jul 2013 17:16:03 GMT

Hi,

I tried it. but not getting how to store qvw into qvd.

Since we are fetching qvw the script look like this..

tab:

binary qvapp.qvw;

store tab into app.qvd;

Here if I use table name like above it gives error. Please help me in storing qvw into qvd;

Re: Clubbing apps without soure

Fri, 05 Jul 2013 04:47:19 GMT

Its working for me..

Find attachment. It may help you.

Karthik