Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
That method seems quite over enginerred and slow. Why can't you do all of those stages in one QVW?
Adding a button was just an idea. The thing is I have to run 3 different QVWs one by one.
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.
Can you please tell me more about publisher. This concept is new to me. Thanks
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
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.
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.
do you have any idea, how it can be done?