Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
souadouert
Specialist
Specialist

SET ANALYSIS

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

1 Solution

Accepted Solutions
sunny_talwar

May be this

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

View solution in original post

2 Replies
sunny_talwar

May be this

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

souadouert
Specialist
Specialist
Author

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)