topic Show rows where both statuses are used in QlikView https://community.qlik.com/t5/QlikView/Show-rows-where-both-statuses-are-used/m-p/89530#M509029 <HTML><HEAD></HEAD><BODY><P>I have a list box in which the user is supposed to select 2 statuses - in this example it's Building Non-Prod and Closed - and see the avg days between the two steps in the charts. As you can see, however, it's showing data for tickets that are not hitting BOTH of the statuses. Any idea how to get this working?</P><P></P><P><IMG alt="2018-09-19_10-23-55.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213965_2018-09-19_10-23-55.jpg" style="width: 620px; height: 250px;" /></P></BODY></HTML> Wed, 19 Sep 2018 17:27:01 GMT cbaqir 2018-09-19T17:27:01Z Show rows where both statuses are used https://community.qlik.com/t5/QlikView/Show-rows-where-both-statuses-are-used/m-p/89530#M509029 <HTML><HEAD></HEAD><BODY><P>I have a list box in which the user is supposed to select 2 statuses - in this example it's Building Non-Prod and Closed - and see the avg days between the two steps in the charts. As you can see, however, it's showing data for tickets that are not hitting BOTH of the statuses. Any idea how to get this working?</P><P></P><P><IMG alt="2018-09-19_10-23-55.jpg" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/213965_2018-09-19_10-23-55.jpg" style="width: 620px; height: 250px;" /></P></BODY></HTML> Wed, 19 Sep 2018 17:27:01 GMT https://community.qlik.com/t5/QlikView/Show-rows-where-both-statuses-are-used/m-p/89530#M509029 cbaqir 2018-09-19T17:27:01Z Re: Show rows where both statuses are used https://community.qlik.com/t5/QlikView/Show-rows-where-both-statuses-are-used/m-p/89531#M509030 <HTML><HEAD></HEAD><BODY><H1 style="font-weight: normal; font-size: 26px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f5faf0;"><A _jive_internal="true" class="font-color-normal" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/17/and-or" style="font-weight: inherit; font-style: inherit; font-family: inherit; color: #3d3d3d;">AND and OR</A></H1></BODY></HTML> Wed, 19 Sep 2018 18:17:38 GMT https://community.qlik.com/t5/QlikView/Show-rows-where-both-statuses-are-used/m-p/89531#M509030 m_woolf 2018-09-19T18:17:38Z