0 Replies Latest reply: Feb 27, 2018 2:53 PM by Brian McNamara RSS

    I am trying to count items that occur in a date window

    Brian McNamara

      Hi,

      I have an Item i can't solve.  I need to count distinct email addresses when they have an action type = to "Success"

      and

      They are from a Start date to plus 3 days from the start date.

       

      In SQL along the lines of-

      select count(distinct case when status = 'Success' and datediff(day,CreatedDate,StartDate)<=3 then email end)

       

      I think I need set Anlysis syntax but I cant get it right.

      this is in Qlik Sense

       

      Thanks for any help provided,

      Brian