https://community.qlik.com/t5/QlikView/If-with-multiple-Firstsorted-value-conditions/m-p/1982187#M1221050 <P>please post some sample data and your expected result.</P> Sat, 17 Sep 2022 10:40:09 GMT MarcoWedel 2022-09-17T10:40:09Z https://community.qlik.com/t5/QlikView/If-with-multiple-Firstsorted-value-conditions/m-p/1982102#M1221046 <P>I'm trying to create an if statement that evaluates multiple Firstsorted values.</P> <P>To simplify lets say I want to evaluate when the most recent [Status] is 'Pending' and the most recent [PendingDate] is equal to or before today. Also I cannot do this via a script, so I'd need an expression. I've gotten it work for each criteria, but when I try to include both it stops working.&nbsp;&nbsp;</P> <P>First post so hopefully I'm in the right place and given everything I need.&nbsp;</P> Fri, 16 Sep 2022 17:04:48 GMT https://community.qlik.com/t5/QlikView/If-with-multiple-Firstsorted-value-conditions/m-p/1982102#M1221046 Jmoore 2022-09-16T17:04:48Z https://community.qlik.com/t5/QlikView/If-with-multiple-Firstsorted-value-conditions/m-p/1982187#M1221050 <P>please post some sample data and your expected result.</P> Sat, 17 Sep 2022 10:40:09 GMT https://community.qlik.com/t5/QlikView/If-with-multiple-Firstsorted-value-conditions/m-p/1982187#M1221050 MarcoWedel 2022-09-17T10:40:09Z