topic Re: Get All Rows of Record Based on Criteria For One or More Rows in QlikView https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387764#M559075 <HTML><HEAD></HEAD><BODY><P>Oh, I thought you wanted all approvers. Ok, try changing the expression to </P><P></P><P>MaxString({&lt;ID=p({&lt;Status={'Approved','Current'}&gt;}ID)&gt;} Status)</P></BODY></HTML> Tue, 21 May 2013 14:00:11 GMT Gysbert_Wassenaar 2013-05-21T14:00:11Z Get All Rows of Record Based on Criteria For One or More Rows https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387760#M559071 <HTML><HEAD></HEAD><BODY><P>Hi all, this is a follow-up to my earlier request (<A _jive_internal="true" class="loading" href="https://community.qlik.com/message/344623" title="http://community.qlik.com/message/344623">http://community.qlik.com/message/344623</A>).&nbsp; I'm looking how to apply the logic to a pivot table to get all approver status' when one or more of the approvers for a particular ID have a specific approval status.&nbsp; In the attached app, I want to get all approval status' if one or more of the approvers have a status of either current or approved.&nbsp; The catch is that it needs to be based on the approvers that have been selected.&nbsp; </P><P></P><P>If I select "Approved" or "Current", obviously the app is only going to return records with that status (I would also want to get future records for the selections if a different selected approver is either current or has approved).&nbsp; I've tried various aggr and if statements but haven't been able to come up with an expression that accomplishes what I'm looking for.</P><P></P><P>In the example, if I select just Harry and Bill, then I would want the app to only return ID=20 and not ID=5.&nbsp; Additionally, ID 20 should return just Bill and Harry and their status'.&nbsp; I.E. I want to display all the status' of records (based on approval name selection) where one of the approvers has either approved or is currently approving.&nbsp; I appreciate your help in advance!</P></BODY></HTML> Mon, 20 May 2013 18:09:51 GMT https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387760#M559071 Anonymous 2013-05-20T18:09:51Z Re: Get All Rows of Record Based on Criteria For One or More Rows https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387761#M559072 <HTML><HEAD></HEAD><BODY><P>Does anyone have any ideas on this?</P></BODY></HTML> Tue, 21 May 2013 12:39:04 GMT https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387761#M559072 Anonymous 2013-05-21T12:39:04Z Re: Get All Rows of Record Based on Criteria For One or More Rows https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387762#M559073 <HTML><HEAD></HEAD><BODY><P>See attached qvw. Is that what you're looking for?</P></BODY></HTML> Tue, 21 May 2013 12:49:59 GMT https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387762#M559073 Gysbert_Wassenaar 2013-05-21T12:49:59Z Re: Get All Rows of Record Based on Criteria For One or More Rows https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387763#M559074 <HTML><HEAD></HEAD><BODY><P>Gysbert, this is really close! Thank you so much.&nbsp; The only issue with this is that it shows all approvers after filtering the records and I only want to display the selected approvers.&nbsp; The filtering does exactly what I need though.&nbsp; In the example, it shows Bill, Harry, Joe and Matt when I only want it to show Bill and Harry (the selections).&nbsp; Is this possible?&nbsp; Thank you again.</P></BODY></HTML> Tue, 21 May 2013 13:52:02 GMT https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387763#M559074 Anonymous 2013-05-21T13:52:02Z Re: Get All Rows of Record Based on Criteria For One or More Rows https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387764#M559075 <HTML><HEAD></HEAD><BODY><P>Oh, I thought you wanted all approvers. Ok, try changing the expression to </P><P></P><P>MaxString({&lt;ID=p({&lt;Status={'Approved','Current'}&gt;}ID)&gt;} Status)</P></BODY></HTML> Tue, 21 May 2013 14:00:11 GMT https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387764#M559075 Gysbert_Wassenaar 2013-05-21T14:00:11Z Re: Get All Rows of Record Based on Criteria For One or More Rows https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387765#M559076 <HTML><HEAD></HEAD><BODY><P>Perfect! Thank you, Gysbert. This is extremely helpful.&nbsp; I appreciate the assistance, as always.</P></BODY></HTML> Tue, 21 May 2013 14:03:44 GMT https://community.qlik.com/t5/QlikView/Get-All-Rows-of-Record-Based-on-Criteria-For-One-or-More-Rows/m-p/387765#M559076 Anonymous 2013-05-21T14:03:44Z