Set analysis

[maxime66]

Hi qlikers,

I try to get number of Active policies (state = 'on') at the year before the one selected.

In my exemple i would like to get 1 policy (instead of 2) for year 2017 (when 2018 is selected)

Best regards.

[sunny_talwar · Accepted solution]

Try this

=Count({<state = {'on'}, dates={'$(=dates-1)'}>}  DISTINCT name)

[maxime66]

Thanks Sunny ! it works