https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1562539#M741985 <P>Try this</P><PRE>=Count({&lt;state = {'on'}, dates={'$(=dates-1)'}&gt;} DISTINCT name)</PRE> Thu, 28 Mar 2019 16:06:58 GMT sunny_talwar 2019-03-28T16:06:58Z https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1562538#M741984 <P>Hi qlikers,</P><P>I try to get number of Active policies (state = 'on') at the year before the one selected.</P><P>In my exemple i would like to get 1 policy (instead of 2) for year 2017 (when 2018 is selected)</P><P>Best regards.</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1562538#M741984 maxime66 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1562539#M741985 <P>Try this</P><PRE>=Count({&lt;state = {'on'}, dates={'$(=dates-1)'}&gt;} DISTINCT name)</PRE> Thu, 28 Mar 2019 16:06:58 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1562539#M741985 sunny_talwar 2019-03-28T16:06:58Z https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1562549#M741986 <P>Thanks Sunny ! it works</P> Thu, 28 Mar 2019 16:38:39 GMT https://community.qlik.com/t5/QlikView/Set-analysis/m-p/1562549#M741986 maxime66 2019-03-28T16:38:39Z