https://community.qlik.com/t5/App-Development/Filter-applications-in-relation-to-a-formula/m-p/1600295#M44381 <P>Good morning, everyone.</P><P>&nbsp;</P><P>I have a rather strange problem with an expression of a column I have defined. I have at my disposal a table to which I have added a dimension that is defined by this expression:</P><P>=(IF(peri = 'Occ' OR rdv = 'Sans' OR ISNULL(plage) OR plage &gt; date<BR />,if(date_terminee &lt;= date_contrat,'Oui','Non')<BR />,if(DATE(FLOOR(date_terminee)) &lt;= DATE(FLOOR(date_rdv)),'Oui','Non')<BR />))</P><P>&nbsp;</P><P>The problem then occurs. When I want to filter on'No' for example. Qlik will apply all these conditions without taking into account my choice which will give me an erroneous result. I can't understand his logic.</P><P>I hope I have been clear enough because I cannot release data that is confidential. Thank you for your answer</P> Tue, 09 Jul 2019 09:45:00 GMT btheo 2019-07-09T09:45:00Z https://community.qlik.com/t5/App-Development/Filter-applications-in-relation-to-a-formula/m-p/1600295#M44381 <P>Good morning, everyone.</P><P>&nbsp;</P><P>I have a rather strange problem with an expression of a column I have defined. I have at my disposal a table to which I have added a dimension that is defined by this expression:</P><P>=(IF(peri = 'Occ' OR rdv = 'Sans' OR ISNULL(plage) OR plage &gt; date<BR />,if(date_terminee &lt;= date_contrat,'Oui','Non')<BR />,if(DATE(FLOOR(date_terminee)) &lt;= DATE(FLOOR(date_rdv)),'Oui','Non')<BR />))</P><P>&nbsp;</P><P>The problem then occurs. When I want to filter on'No' for example. Qlik will apply all these conditions without taking into account my choice which will give me an erroneous result. I can't understand his logic.</P><P>I hope I have been clear enough because I cannot release data that is confidential. Thank you for your answer</P> Tue, 09 Jul 2019 09:45:00 GMT https://community.qlik.com/t5/App-Development/Filter-applications-in-relation-to-a-formula/m-p/1600295#M44381 btheo 2019-07-09T09:45:00Z