7 Replies Latest reply: Jun 27, 2016 5:12 AM by Varsha Vig RSS

    How to create a "IsYesterday" field in QlikView Script

    Siddharth Sharma

      how to create a "IsYesterday" field in Qlikview Script ...problem is ..if today date is monday then I need IsYesterday to pick Friday and not Sunday.

       

         

      if today is say 27th June 2016 ( Week end day as Monday)
      Date_DIsYesterday
      27-06-2016No
      26-06-2016No
      24-06-2016Yes
      if today is say 23rd June 2016 ( Week end day as Thrusday)
      Date_DIsYesterday
      23-06-2016No
      22-06-2016Yes

       

       

       

       

       

       

      Thanks in Advance !!!