Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to calculate this expression in qlik
=IF(AND(Status="Executed",COUNTIFS('ABC1'!A:A,A2,'ABC1'!$AQ:$AQ,"Expired")>0),"False","True")
What's the logic behind the expression?
can you please post some sample data and your expected result?