1 Reply Latest reply: Mar 18, 2016 12:20 PM by Mike Czerwonky RSS

    Filter returns all values

    Christopher Hardy

      I have the current filter set up to return orders that were placed yesterday:

       

      =[OpenOrd Date Ordered]=num(today()-1)

       

      It works great....However, If there were no orders placed yesterday, It will return all orders we have in Qlikview.

       

      How can I modify the formula to bring in no data instead of all data when no orders were placed yesterday? Or if there were no orders yesterday, maybe it could bring back orders from 2 days ago if needed?

       

      Thanks for the help again.