topic Re: SET ANALYSIS in QlikView

SET ANALYSIS

souadouert — Wed, 14 Mar 2018 13:45:46 GMT

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

Re: SET ANALYSIS

sunny_talwar — Wed, 14 Mar 2018 13:49:44 GMT

May be this

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

Re: SET ANALYSIS

souadouert — Thu, 15 Mar 2018 06:58:20 GMT

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)