Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
shubham_kumar
Contributor III

Just wondering about few things regarding the QlikView operation. When we update with new script and tab, can we just re-load the updated one while leaving the old one?

Example:  Data Loader Script has few tabs example (ETUS,FDUS,COUS,SST, FM & MS). Suppose we added FM& MS recently and want only to execute those new one. Is that possible?

If yes could you please explain the procedure. Which will save some time for re-execution for the same thing again and again.

Thanking you in advance.

Best Regards,

Shubham Kumar

3 Replies
siva_boggarapu
Contributor II

Just wondering about few things regarding the QlikView operation. When we update with new script and tab, can we just re-load the updated one while leaving the old one?

Hi Shubham,

You can use an if statement together with variables to select which parts of the load/select script to execute.

If you create variables for each product with a value of 0 or 1 you can use this value together with IF to execute parts of the script.

Example:

set loadetus = 1;

if($(loadetus)<>0) then
      
SELECT 
        OU_Pnr_id,
        OU_PnrLeg_id,
        OU_Airline,
        OU_BaseClass,
        OU_FromAirRegion

       

FROM         dbo.OverUnder_history with (nolock)...  end if


Let me know if you have any questions.

Just wondering about few things regarding the QlikView operation. When we update with new script and tab, can we just re-load the updated one while leaving the old one?

Hi,

   All you need to do is add, "ADD" keyword before the load statement in your new tab.

   And do the partial load.

   It will load only the tables which have Add, Replace prefix with load statement.

   For more information about Partial load, Look into Qlikview Help.

   Hope this will help you

Regards,

Kaushik Solanki

Not applicable

Just wondering about few things regarding the QlikView operation. When we update with new script and tab, can we just re-load the updated one while leaving the old one?

Hi Shubham,

If you are uploading a new data/ scripts and you dont want to run the whole script you can try partial load of the dtat you newly updated. In qlikview there is an option in file tab called Partial load where it loads the newly added script / data give a try to it if it didn't worked let us know to sort a new solution for your problem.

Thanks a lot

Bradd

Community Browser