7 Replies Latest reply: Sep 18, 2015 6:21 AM by Kevin Stephenson RSS

    Date Filter in Set Analysis



      Using Qlik Sense


      I have an expression


      COUNT ({<[Current Status] = {"Awaiting"}>}[Claim Ref]) And [Current Status Date] = Date(Today(-14))


      So what I need the expression to do is locate a claim where the status is Awaiting and the date in the Current status date column is from 14 days ago or older.


      Any help would be much appreciated


      Thanks in advance