2 Replies Latest reply: Feb 7, 2018 5:46 PM by omar bensalem RSS

    YTD / Prior YTD

    Steven Caruthers

      Hello,

       

      I'm trying to create a set analysis that will be used in the Nprinting Formulas area. Most set analysis's work between Qlik Sense and Nprint.

       

      I am using SUM(IF([Service Year] = YEAR(Today()), [Case Count])) to return the Case Count for the Current YTD.

       

      However, I cannot figure out how to get the Prior YTD.  I tried the YEAR(Today())-1 in the above, but it returns the entire year. I need it to cut off at the current day (rolling forward).

       

       

      Anyone have a suggestion?

       

      Thanks