https://community.qlik.com/t5/QlikView/Location-Based-Daily-Participants/m-p/1602209#M444417 <P>Can you give more info? what's the expected result with that data?</P><P>Maybe: =Sum({&lt;Event_Date={"&gt;=$(=Date(Max(Event_Date)-30))"}&gt;} Participants)&nbsp;</P> Mon, 15 Jul 2019 09:05:00 GMT rubenmarin 2019-07-15T09:05:00Z https://community.qlik.com/t5/QlikView/Location-Based-Daily-Participants/m-p/1602035#M444410 <P>In the table below, I would like to count more than 30 days based on location-based daily participants</P><P>Help me</P> Sat, 13 Jul 2019 16:59:57 GMT https://community.qlik.com/t5/QlikView/Location-Based-Daily-Participants/m-p/1602035#M444410 gazimaras 2019-07-13T16:59:57Z https://community.qlik.com/t5/QlikView/Location-Based-Daily-Participants/m-p/1602209#M444417 <P>Can you give more info? what's the expected result with that data?</P><P>Maybe: =Sum({&lt;Event_Date={"&gt;=$(=Date(Max(Event_Date)-30))"}&gt;} Participants)&nbsp;</P> Mon, 15 Jul 2019 09:05:00 GMT https://community.qlik.com/t5/QlikView/Location-Based-Daily-Participants/m-p/1602209#M444417 rubenmarin 2019-07-15T09:05:00Z https://community.qlik.com/t5/QlikView/Location-Based-Daily-Participants/m-p/1610352#M445083 <P>Did Ruben's post help you resolve things?&nbsp; If so, please be sure to give him credit by clicking the Accept as Solution button on his post.&nbsp; If not, please provide further information, or if you resolved some other way, it would be great if you would post what you did for others to learn and you can also mark that post as the solution in that case as well.</P> <P>Regards,<BR />Brett</P> Wed, 07 Aug 2019 16:19:44 GMT https://community.qlik.com/t5/QlikView/Location-Based-Daily-Participants/m-p/1610352#M445083 Brett_Bleess 2019-08-07T16:19:44Z