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

    Date Filter in Set Analysis

    Kevin Stephenson

      HI

       

      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