set expression

[#1]

Hi Team,

How do we write the below in set expression. Please help

i want the count of tickets that are resolved within 7 days.

Count(if((ResolvedDate -TicketSubmitDate )<=7,TicketID))

[Gysbert_Wassenaar]

Try Count({<TicketID={"=ResolvedDate -TicketSubmitDate<=7"}>} TicketID))

[#3]

this did not work

[Gysbert_Wassenaar]

Then it's not possible to uniquely identify a ticketid by its resolveddate and ticketsubmitdate. Perhaps this document will explain to you why: set_analysis_intra-record.qvw