topic Showing two Alternate States in one table? in QlikView https://community.qlik.com/t5/QlikView/Showing-two-Alternate-States-in-one-table/m-p/977718#M334007 <HTML><HEAD></HEAD><BODY><P>Hi all - I'm trying to make a table which shows the result of a comparative analysis, but I don't know how to reference both alternate states of my field in question.&nbsp; What I would like to do is show the user's two selections in the field [Buyer] in one straight table object with a number of other fields, but QlikView is rejecting my expression.&nbsp; I thought it would have been something like;</P><P></P><P>=sum({&lt;Buyer={AS1::Contractor,AS2::Contractor}&gt;} Amounts)</P><P></P><P>Unfortunately, that doesn't work.&nbsp; Any help?</P></BODY></HTML> Fri, 04 Sep 2015 14:21:49 GMT 2015-09-04T14:21:49Z Showing two Alternate States in one table? https://community.qlik.com/t5/QlikView/Showing-two-Alternate-States-in-one-table/m-p/977718#M334007 <HTML><HEAD></HEAD><BODY><P>Hi all - I'm trying to make a table which shows the result of a comparative analysis, but I don't know how to reference both alternate states of my field in question.&nbsp; What I would like to do is show the user's two selections in the field [Buyer] in one straight table object with a number of other fields, but QlikView is rejecting my expression.&nbsp; I thought it would have been something like;</P><P></P><P>=sum({&lt;Buyer={AS1::Contractor,AS2::Contractor}&gt;} Amounts)</P><P></P><P>Unfortunately, that doesn't work.&nbsp; Any help?</P></BODY></HTML> Fri, 04 Sep 2015 14:21:49 GMT https://community.qlik.com/t5/QlikView/Showing-two-Alternate-States-in-one-table/m-p/977718#M334007 2015-09-04T14:21:49Z Re: Showing two Alternate States in one table? https://community.qlik.com/t5/QlikView/Showing-two-Alternate-States-in-one-table/m-p/977719#M334008 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Try =sum({&lt;Buyer=AS1::Contractor&gt;+&lt;Buyer=AS2::Contractor&gt;} Amounts)</SPAN></P></BODY></HTML> Sat, 05 Sep 2015 08:37:33 GMT https://community.qlik.com/t5/QlikView/Showing-two-Alternate-States-in-one-table/m-p/977719#M334008 Gysbert_Wassenaar 2015-09-05T08:37:33Z