3 Replies Latest reply: May 16, 2016 5:37 AM by Oliver Annells RSS

    understanding the 'better calendar script'

    Oliver Annells

      Hi

       

      Reference the very good blog post here:

      http://qlikviewcookbook.com/2015/05/better-calendar-scripts/

       

      I was testing the initial part of the load and getting a result I dont understand.

       

      This is what I am loading:

       

      LOAD

           min(fieldvalue('Order Header Invoice Date',recno()))-1    as mindate

          ,max(fieldvalue('Order Header Invoice Date',recno()))     as maxdate

      AUTOGENERATE

          fieldvaluecount('Order Header Invoice Date')

      ;

       

      Of the 591 distinct dates in the 'Order Header Invoice Date' it returns mindate as one less than the first date in the 'Order Header Invoice Date' which is correct; however the maxdate value is simply '?'

       

      Is this monday morning stupidity (again) or has something gone wrong or been lost in translation

       

      Thanks

      Oli