SET ANALYSIS

[souadouert]

Hello,

I want to count the number of client in current situation where , this client client statut = active in 12/2017 i used this expression but i dont know where is the problem

count({<DATE={$(DATE_SITUATION)},CLIENT_STATUT={$(={<DATE= {$(='201701'},='ACTIF'))}>} idclient))

[sunny_talwar · Accepted solution]

May be this

Sum({<DATE = {$(DATE_SITUATION)}, CLIENT = P({<CLIENT_STATUT = {'ACTIF'}, DATE = {'201701'}>})>} PLACEMENT_ENCOURS_TND)

[souadouert]

Hello sunny thank you for your help , I used this expression

COUNT(DISTINCT {<CLIENT_ID=P({<statut_client={'actif'},DATE={'20171229'}>}),DATE={$(DATE_SELECTION)}>}CLIENT_ID)

so NOW I NEED  to modify this expressin , I want to replace DATE={'20171229'} with  the MIN(DATE) between

20171229 and $(DATE_SELECTION)