topic Re: set expression in Archived Groups https://community.qlik.com/t5/Archived-Groups/set-expression/m-p/993194#M1753 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Try Count({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">TicketID={"=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ResolvedDate -TicketSubmitDate&lt;=7</SPAN>"}</SPAN>&gt;} TicketID))</SPAN></P></BODY></HTML> Fri, 27 Nov 2015 06:28:23 GMT Gysbert_Wassenaar 2015-11-27T06:28:23Z set expression https://community.qlik.com/t5/Archived-Groups/set-expression/m-p/993193#M1752 <HTML><HEAD></HEAD><BODY><P>Hi Team,</P><P></P><P>How do we write the below in set expression. Please help</P><P></P><P>i want the count of tickets that are resolved within 7 days.</P><P></P><P>Count(if((ResolvedDate -TicketSubmitDate )&lt;=7,TicketID))</P></BODY></HTML> Tue, 22 Jul 2025 17:59:49 GMT https://community.qlik.com/t5/Archived-Groups/set-expression/m-p/993193#M1752 2025-07-22T17:59:49Z Re: set expression https://community.qlik.com/t5/Archived-Groups/set-expression/m-p/993194#M1753 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Try Count({&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">TicketID={"=<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">ResolvedDate -TicketSubmitDate&lt;=7</SPAN>"}</SPAN>&gt;} TicketID))</SPAN></P></BODY></HTML> Fri, 27 Nov 2015 06:28:23 GMT https://community.qlik.com/t5/Archived-Groups/set-expression/m-p/993194#M1753 Gysbert_Wassenaar 2015-11-27T06:28:23Z Re: set expression https://community.qlik.com/t5/Archived-Groups/set-expression/m-p/993195#M1754 <HTML><HEAD></HEAD><BODY><P>this did not work <IMG src="https://community.qlik.com/legacyfs/online/emoticons/sad.png" /></P></BODY></HTML> Fri, 27 Nov 2015 07:04:04 GMT https://community.qlik.com/t5/Archived-Groups/set-expression/m-p/993195#M1754 2015-11-27T07:04:04Z Re: set expression https://community.qlik.com/t5/Archived-Groups/set-expression/m-p/993196#M1755 <HTML><HEAD></HEAD><BODY><P>Then it's not possible to uniquely identify a ticketid by its resolveddate and ticketsubmitdate. Perhaps this document will explain to you why: <A href="https://community.qlik.com/docs/DOC-4563">set_analysis_intra-record.qvw</A></P></BODY></HTML> Fri, 27 Nov 2015 07:08:07 GMT https://community.qlik.com/t5/Archived-Groups/set-expression/m-p/993196#M1755 Gysbert_Wassenaar 2015-11-27T07:08:07Z