7 Replies Latest reply: Jun 28, 2012 6:06 PM by surfah99 RSS

    Adjust Expression to Calculate Prior Year Values

      Hi there,

       

      I'm trying to write an expression that will return the number of sales leads created from the same day last year (day-of-week adjusted). This is what I have so far:

       

      Sum ({$<date_activity={'=$(=Date(Today(date_activity)-364))'}>} leads_created)

       

      To be honest, I'm so new to QlikView that I don't really know what this formula even says...I just copied it from another thread and added the '-364' to try to adjust the Activity Date ('date_activity').

       

      If today's date in my DB is 6-26-12, and I want leads created from 6-30-11 (364 days ago), how would I write the expression? I want this to be a rolling calculation, so hard-coding a date won't work...

       

      Thanks so much!

      Stephen