https://community.qlik.com/t5/QlikView/set-analysis-date/m-p/1822825#M1213714 <P>Hi!</P><P>Following question:</P><P>I have this formula</P><P><STRONG>sum(</STRONG><BR /><STRONG>{&lt; Cust_number = {'70407'},[CLM_Type]={'claim'} &gt;}</STRONG><BR /><STRONG>[CLM_PickupTime])</STRONG><BR /><STRONG>/</STRONG><BR /><STRONG>sum(</STRONG><BR /><STRONG>{&lt; Cust_number = {'70407'},[CLM_Type]={'claim'} &gt;}</STRONG><BR /><STRONG>[CLM_Counter])</STRONG></P><P>&nbsp;</P><P>Then i have the value CLM_Date (MMM-YY example May 21)&nbsp; and i want to see the result from the formula where the date is bigger then May 21.&nbsp;</P><P>But i dont know which syntax i have to use in the formula for this date expression...</P><P>Thank you for answers.</P><P>Greetings Roland</P> Sat, 17 Jul 2021 13:38:15 GMT rolandg1881 2021-07-17T13:38:15Z https://community.qlik.com/t5/QlikView/set-analysis-date/m-p/1822825#M1213714 <P>Hi!</P><P>Following question:</P><P>I have this formula</P><P><STRONG>sum(</STRONG><BR /><STRONG>{&lt; Cust_number = {'70407'},[CLM_Type]={'claim'} &gt;}</STRONG><BR /><STRONG>[CLM_PickupTime])</STRONG><BR /><STRONG>/</STRONG><BR /><STRONG>sum(</STRONG><BR /><STRONG>{&lt; Cust_number = {'70407'},[CLM_Type]={'claim'} &gt;}</STRONG><BR /><STRONG>[CLM_Counter])</STRONG></P><P>&nbsp;</P><P>Then i have the value CLM_Date (MMM-YY example May 21)&nbsp; and i want to see the result from the formula where the date is bigger then May 21.&nbsp;</P><P>But i dont know which syntax i have to use in the formula for this date expression...</P><P>Thank you for answers.</P><P>Greetings Roland</P> Sat, 17 Jul 2021 13:38:15 GMT https://community.qlik.com/t5/QlikView/set-analysis-date/m-p/1822825#M1213714 rolandg1881 2021-07-17T13:38:15Z