topic Creating a Past Due list box in QlikView https://community.qlik.com/t5/QlikView/Creating-a-Past-Due-list-box/m-p/1184269#M885631 <HTML><HEAD></HEAD><BODY><P>Hi All-</P><P></P><P>I am trying to create a list box that shows me past due items.&nbsp; The data would be using 3 different columns, column 1: Activities, Column 2: Planned End Date, Column 3: Status.&nbsp; What i would like to be able to accomplish is "if planned end date is less than today's date and status is not marked as complete(so anything other than complete), then to show items<SPAN style="font-size: 13.3333px;">(activities)</SPAN>".&nbsp; I can not seem to find a possible solution to make this happen.&nbsp; Hope someone is able to help.</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Creating a Past Due list box https://community.qlik.com/t5/QlikView/Creating-a-Past-Due-list-box/m-p/1184269#M885631 <HTML><HEAD></HEAD><BODY><P>Hi All-</P><P></P><P>I am trying to create a list box that shows me past due items.&nbsp; The data would be using 3 different columns, column 1: Activities, Column 2: Planned End Date, Column 3: Status.&nbsp; What i would like to be able to accomplish is "if planned end date is less than today's date and status is not marked as complete(so anything other than complete), then to show items<SPAN style="font-size: 13.3333px;">(activities)</SPAN>".&nbsp; I can not seem to find a possible solution to make this happen.&nbsp; Hope someone is able to help.</P><P></P><P>Thanks,</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Creating-a-Past-Due-list-box/m-p/1184269#M885631 2020-11-25T16:16:04Z