4 Replies Latest reply: Apr 3, 2016 7:32 AM by Deepanshu Chamoli RSS

    New Data

    Deepanshu Chamoli

      Hello All

       

      Please help me in the below query. I read the qlik documents but still confused.

       

      I have connected ODBC with Qlik Sense. In SQL the data is updated every day. As there are millions of data approx 200 million data, I need to load the new data only so that it takes less time to upload the data in qvd.

       

      I have created a variable using LET statement which contains maximum date. I am using the variable in the where statement to get the new data.

       

      The problem I am facing is when I load the data first time; it loads the data successfully in it. But when I load the data multiple times the output is different sometimes it load all data sometimes 0 data

       

      Ideally when I load the data again and again, the output shows 0 upload because the new data is uploaded.

       

      I don’t have the qvd as the qvd is in other environment.

       

      Can someone please guide the best method for incremental load in qvd and correct me also.

       

      stalwar1

      swuehl

       

      I will be grateful if someone attach the qvd where the above example suits

       

      Thanks

      Deepanshu