https://community.qlik.com/t5/App-Development/Comparing-two-dates-at-once/m-p/1728935#M55576 <P>Would you be able to share sample data with expected output?</P> Fri, 17 Jul 2020 21:31:54 GMT Kushal_Chawda 2020-07-17T21:31:54Z https://community.qlik.com/t5/App-Development/Comparing-two-dates-at-once/m-p/1728898#M55572 <P>I have an issue where I have two dates, a start date and an end date. I need to be able to count active policies between these two dates. My current implementation is&nbsp;count(Distinct {&lt;Started = {'$&gt;=Ended'}&gt;} PolicyNumber) with Started as my dimension, but I am not having ended policies properly removed from the data. Any suggestions on how to properly account for when a policy ends?</P> Mon, 20 Dec 2021 21:08:46 GMT https://community.qlik.com/t5/App-Development/Comparing-two-dates-at-once/m-p/1728898#M55572 benst12 2021-12-20T21:08:46Z https://community.qlik.com/t5/App-Development/Comparing-two-dates-at-once/m-p/1728935#M55576 <P>Would you be able to share sample data with expected output?</P> Fri, 17 Jul 2020 21:31:54 GMT https://community.qlik.com/t5/App-Development/Comparing-two-dates-at-once/m-p/1728935#M55576 Kushal_Chawda 2020-07-17T21:31:54Z