topic Reloading different QVWs in continuation in QlikView

Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 13:04:46 GMT

Hi All,

I am new to Qlikview and working on project where I have multiple QVWs. L1 which loads the raw data in and converts it into QVDs. L2 which loads data from QVD generated by L1 and transforms the data (joining multiple tables and filtering unwanted data) and creates QVDs and at Last L4 which brings data into qlikview from QVDs created by L2 and represent the data in graphical format (Dashboards).

Now the challenge is I have to load all 3 QVWs one by one. First I open and run L1 then L2 and then L4. So just wandering if there is any way I can place a button on L4 which will load L1 so that it pull data from and convert that into QVDs then Load L2 and then L4.

Any help would be greatly appreciated.

Thanks in advance.

Re: Reloading different QVWs in continuation

giakoum — Tue, 17 Jun 2014 13:11:04 GMT

why do you need a button? So that the user initiates it?

Otherwise, just use the publisher, when one tasks is ready, it will trigger the next one.

Re: Reloading different QVWs in continuation

ThornOfCrowns — Tue, 17 Jun 2014 13:13:44 GMT

That method seems quite over enginerred and slow. Why can't you do all of those stages in one QVW?

Re: Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 13:14:37 GMT

Adding a button was just an idea. The thing is I have to run 3 different QVWs one by one.

Re: Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 13:17:52 GMT

Well this is the model that we are following and I can not change that .

I tried adding a button with multiple actions in L4. When I click it is opening L1 however it does not load it.

Re: Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 13:18:52 GMT

Can you please tell me more about publisher. This concept is new to me. Thanks

Re: Reloading different QVWs in continuation

Tue, 17 Jun 2014 13:27:13 GMT

I'm sorry, but what do you mean it "is the model"? You could perform all of the same operations in the same QVW, and it would probably optimize the process. It would definitely make it easier on you

Re: Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 13:40:04 GMT

yes you are right, but I have just started working on Qlikview so it would not be fair for me to comment on this. But is there any way, we can call next QVW at the end of the script of each QVW.

Re: Reloading different QVWs in continuation

Ricardo_Gerhard — Tue, 17 Jun 2014 13:40:40 GMT

Kamal, when you are developing a dashboard, you´ll open the QVW and reload sometimes. It´s developer envrioment.

But, with Qlikview Server and production enviroment, you´ll create a task in Qlikview Server to reload with hierarquy.

You don´t need Qlikview Publisher in this case, only reload with dependencies.

Re: Reloading different QVWs in continuation

kamal_sanguri — Tue, 17 Jun 2014 14:58:33 GMT

do you have any idea, how it can be done?

Re: Reloading different QVWs in continuation

Ricardo_Gerhard — Tue, 17 Jun 2014 15:03:16 GMT

Do you know how Qlikview Server works? Can you open Qlikview Management Console to understand?

Re: Reloading different QVWs in continuation

kamal_sanguri — Wed, 18 Jun 2014 18:14:38 GMT

already answered :

http://community.qlik.com/message/550799?et=watches.email.thread#550799