Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
souadouert
Contributor III

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

Re: SET ANALYSIS

May be this

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

2 Replies

Re: SET ANALYSIS

May be this

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

souadouert
Contributor III

Re: SET ANALYSIS

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)

Community Browser