Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Brip51
Creator
Creator

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

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

0 Replies