https://community.qlik.com/t5/QlikView/If-Condition/m-p/2059041#M1223234 <P>Hello guys ,</P> <P>This is my expression Sum(Oscar_Ecart)</P> <P>i want to take the top 10 flops with a condition if&nbsp; to take true value 1 or 0&nbsp;&nbsp;</P> <P>i tried this but it will not take into account the negative values&nbsp;</P> <P>if(rank(sum(oscar_ecart)&lt;=10,1,0)&nbsp;</P> <P>&nbsp;</P> <P>Thank you in advance !</P> <P>&nbsp;</P> Tue, 11 Apr 2023 09:53:18 GMT YoussefKacem1 2023-04-11T09:53:18Z https://community.qlik.com/t5/QlikView/If-Condition/m-p/2059041#M1223234 <P>Hello guys ,</P> <P>This is my expression Sum(Oscar_Ecart)</P> <P>i want to take the top 10 flops with a condition if&nbsp; to take true value 1 or 0&nbsp;&nbsp;</P> <P>i tried this but it will not take into account the negative values&nbsp;</P> <P>if(rank(sum(oscar_ecart)&lt;=10,1,0)&nbsp;</P> <P>&nbsp;</P> <P>Thank you in advance !</P> <P>&nbsp;</P> Tue, 11 Apr 2023 09:53:18 GMT https://community.qlik.com/t5/QlikView/If-Condition/m-p/2059041#M1223234 YoussefKacem1 2023-04-11T09:53:18Z