topic Re: Set analysis Year-1 in QlikView

Set analysis Year-1

maxime66 — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 28 Aug 2017 14:26:59 GMT

May be this

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

maxime66 — Mon, 28 Aug 2017 14:32:46 GMT

Thnaks sunny !! perfect

its_anandrjs — Mon, 28 Aug 2017 14:36:43 GMT

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 — Mon, 28 Aug 2017 14:38:05 GMT

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))