Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this
=Count({<state = {'on'}, dates={'$(=dates-1)'}>} DISTINCT name)
Try this
=Count({<state = {'on'}, dates={'$(=dates-1)'}>} DISTINCT name)
Thanks Sunny ! it works