topic Re: set analysis with p() funciton in QlikView

set analysis with p() funciton

souadouert — Thu, 15 Mar 2018 06:56:55 GMT

Hello,

I Used this expression to count client , with activ statut IN 20171229

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

Re: set analysis with p() funciton

sunny_talwar — Thu, 15 Mar 2018 08:55:43 GMT

This

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

Is your DATE field in number format?

Re: set analysis with p() funciton

souadouert — Thu, 15 Mar 2018 09:05:51 GMT

Hello sunny ,

Yes in number format

Re: set analysis with p() funciton

sunny_talwar — Thu, 15 Mar 2018 09:07:20 GMT

So did this work?

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

Re: set analysis with p() funciton

souadouert — Thu, 15 Mar 2018 09:10:28 GMT

Thank you sunny