1 Reply Latest reply: May 2, 2017 2:35 AM by Anil Babu Samineni RSS

    Load data into a temporary table

    Tsiry Elhy

      Hello Community,

       

      I need help.

       

      My situation :

       

      I have several rows of data for the years 2015,2016 and 2017 in my database while my QlikView report must output a graph every day with the existing data (from 2015 to 2017)

      My problem is that loading data from 2015 to 2017 takes a long time.

      What I would like to do then, if possible on QlikView, is to load the data from January 2015 to the previous month of the current month for 2017 early in the month.

       

      For example :

      On 1 May 2017, I load a temporary table containing the data from 01 January 2015 to 30 April 2017.

      Then during the month of May, for my report, I will only reload the data of the month of May, the remains I take them just in my temporary table to avoid reloading the data from 01 Jan 2015 to May 2017 (max date), Since the data from 01 January 2015 to 30 April 2017 no longer change, they are no longer modifiable when we move to a new month.

       

      Thanks in advance for your help.

       

      Tsiry