https://community.qlik.com/t5/Search-the-Community/Date-du-jour/m-p/1866922#M785 <P>Hello</P> <P>I had on problem with the format date which has been resolved.</P> <P>The script below runs perfectly</P> <P>sum({&lt;[Opportunite.Date_relance]={"&lt;=$(=Date(Today(), 'DD/MM/YYYY'))"},[Opportunite.Statut_Commercial]={"En Cours"}&gt;}[Opportunite.EstOpportunite]).</P> <P>&nbsp;</P> <P>Thank you for the great support</P> Mon, 06 Dec 2021 07:40:19 GMT Arnaud35 2021-12-06T07:40:19Z https://community.qlik.com/t5/Search-the-Community/Date-du-jour/m-p/1865346#M772 <P>Bonjour,</P> <P>Ma formule ci-dessous ne fonctionne pas</P> <P>=sum(if([Opportunite.Statut_Commercial]='En cours' and [Opportunite.Date_relance] = Date(today(),'YYYYMMDD'),[Opportunite.EstOpportunite]))</P> <P>&nbsp;</P> <P>La date du jour est-elle bien traduite par Date(today(),'YYYYMMDD') ?</P> Wed, 01 Dec 2021 09:50:44 GMT https://community.qlik.com/t5/Search-the-Community/Date-du-jour/m-p/1865346#M772 Arnaud35 2021-12-01T09:50:44Z https://community.qlik.com/t5/Search-the-Community/Date-du-jour/m-p/1866824#M784 <P>Bonjour,</P> <P>Essayez avec l'analyse des ensembles.</P> <P>=sum({&lt;[Opportunite.Statut_Commercial]={"En cours"},[Opportunite.Date_relance] = {"$(=Date(today(),'YYYYMMDD'))"}&gt;}[Opportunite.EstOpportunite]))</P> <P>&nbsp;</P> <P>-Ashutosh</P> Sun, 05 Dec 2021 12:43:44 GMT https://community.qlik.com/t5/Search-the-Community/Date-du-jour/m-p/1866824#M784 AshutoshBhumkar 2021-12-05T12:43:44Z https://community.qlik.com/t5/Search-the-Community/Date-du-jour/m-p/1866922#M785 <P>Hello</P> <P>I had on problem with the format date which has been resolved.</P> <P>The script below runs perfectly</P> <P>sum({&lt;[Opportunite.Date_relance]={"&lt;=$(=Date(Today(), 'DD/MM/YYYY'))"},[Opportunite.Statut_Commercial]={"En Cours"}&gt;}[Opportunite.EstOpportunite]).</P> <P>&nbsp;</P> <P>Thank you for the great support</P> Mon, 06 Dec 2021 07:40:19 GMT https://community.qlik.com/t5/Search-the-Community/Date-du-jour/m-p/1866922#M785 Arnaud35 2021-12-06T07:40:19Z