3 Replies Latest reply: Mar 8, 2018 6:45 PM by Chi Le RSS

    Generate List of End Dates

    Chi Le

      I have a Calendar table which each Fiscal Year/Period is linked to a date range. For example, Fiscal Year / period 2019002 has dates range from January 29th 2018 to March 4th 2018. I want to create a table with only the date end of each Fiscal Year Period. Is there a way to use Where to extract those dates ? Thank you for your help.

       

      LOAD  Date_DATE0, 

                 [Fiscal year / period_FISCPER]

      FROM

      [Z:\QlikViewStorage\003.QVD\ZJBS0 - JBS\MASTER\FISCAL CALENDAR\ZFISCAL.qvd]

      (qvd)

      Where ;

       

      FYPeriod.JPG