6 Replies Latest reply: Feb 28, 2018 4:09 AM by Pablo Labbe RSS

    Previous YTD Help

    Amit Saini

      Hi All,

       

      Here’s the question I had about qlikview. I want to calculate Previous YTD (Same time frame as the current year) however, whenever I reload my data, the Prev YTD column stays static and the current year data changes based on the new data.

       

      I expect the Prev YTD column to look back in time and fetch data for the same time frame as last year and keep accumulating each time I reload data.

       

      I'm using something like below , but looks like it's not working.

       

      =SUM({$<SalesDate={'>=$(=AddYears(YearStart(Today()),-1))<=$(=AddYears(Date(Today()),-1))'}>}InvoiceSales)

       

       

      Any suggestions?

       

      Regards,

      AS