2 Replies Latest reply: Feb 9, 2018 10:22 AM by Josefina Fasoli RSS

    For loop for Quarter

    Yvonne Han

      Hi,

       

      I'm extracting a large amount of data from a SQL server database. There's a limit on the amount of data that can be pulled per query, so I need to query data quarter by quarter. I'm wondering if there's a for loop function in Qlikview load script that can automate this. So, I'm thinking something like.

       

      For all quarters in current year and last two years

       

      Data:

      Load *;

       

      SQL select *

       

      From my table

      Where mytable.quarter = quarter;

       

      Concatenate  (Although there are several select queries , I would like to have data loaded in the same table in qlikview)

      Next quarter.

       

       

      Is it possible or any other suggestions?

       

      Thanks

       

      Yvonne