3 Replies Latest reply: Aug 10, 2017 9:15 AM by Sasidhar Parupudi RSS

    Qlikview expression based on last 30 working days

    Andrew Moberg



      I'm trying to figure out how to build an expression which does a count of an ID for the past 30 working days. I created a WeekEnd flag but I'm not getting the results I expect:

      count(distinct(if(Date >= Today()-30 AND WeekEndFlag = 0,ID)))

      I believe this is just omitting weekends in the past 30 days. How can I get the past 30 working days (Mon- Fri)?