topic Re: I have an IF statement but How do I exclude values. in QlikView https://community.qlik.com/t5/QlikView/I-have-an-IF-statement-but-How-do-I-exclude-values/m-p/1346635#M831536 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/171606">How to use the IF statement to exclude some un-wanted data in a field?</A></P></BODY></HTML> Fri, 09 Jun 2017 21:56:48 GMT tajmohamed30 2017-06-09T21:56:48Z I have an IF statement but How do I exclude values. https://community.qlik.com/t5/QlikView/I-have-an-IF-statement-but-How-do-I-exclude-values/m-p/1346634#M831535 <HTML><HEAD></HEAD><BODY><P>I wrote an IF statement for filtering past due items. =If([Due Date]&lt;Today(),[Due Date]). Within this expression I want it to filter out anything that is( Status --&nbsp; Not Required, Done) and filter for only (sub-tasks). How would I write an expression for this? </P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/I-have-an-IF-statement-but-How-do-I-exclude-values/m-p/1346634#M831535 mparker123 2020-11-25T16:16:04Z Re: I have an IF statement but How do I exclude values. https://community.qlik.com/t5/QlikView/I-have-an-IF-statement-but-How-do-I-exclude-values/m-p/1346635#M831536 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/171606">How to use the IF statement to exclude some un-wanted data in a field?</A></P></BODY></HTML> Fri, 09 Jun 2017 21:56:48 GMT https://community.qlik.com/t5/QlikView/I-have-an-IF-statement-but-How-do-I-exclude-values/m-p/1346635#M831536 tajmohamed30 2017-06-09T21:56:48Z