Set analysis Year-1

[maxime66]

Hi Qlikers,

i would like to get the number of customers (see expression) for the year before the selected one

I tried some set analysis  but results is always 0

2015 : 3

2016 : 4

thx for your help !!

[sunny_talwar · Accepted solution]

May be this

=Count({$<year = {$(=year-1)}>} DISTINCT If(Aggr(Sum({$<year={$(=year-1)}>}sales), salesman, id_customer, year) > 0, id_customer))

[maxime66]

Thnaks sunny !! perfect

[its_anandrjs]

Try to write

=count( {$<year={$(=Max(year)-1)}>} distinct if(aggr(sum({$<year={$(=Max(year)-1)}>} sales),salesman,id_customer,year)>0,id_customer))

[its_anandrjs]

If you not click on the Year field you did not get any thing on the chart you need dynamically change in expression then use Max in the Expression.

=count( {$<year={$(=Max(year)-1)}>} distinct if(aggr(sum({$<year={$(=Max(year)-1)}>} sales),salesman,id_customer,year)>0,id_customer))