topic Re: Comparing list to Alternate State list in QlikView https://community.qlik.com/t5/QlikView/Comparing-list-to-Alternate-State-list/m-p/877744#M655553 <HTML><HEAD></HEAD><BODY><P>not sure why you need to use alternate state but this expression gives you D </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">only({&lt;List2 -= {'$(=(concat(List1,chr(39)&amp;','&amp;chr(39))))'} &gt;}List2)</SPAN></P></BODY></HTML> Thu, 11 Jun 2015 21:13:53 GMT ramoncova06 2015-06-11T21:13:53Z Comparing list to Alternate State list https://community.qlik.com/t5/QlikView/Comparing-list-to-Alternate-State-list/m-p/877743#M655552 <HTML><HEAD></HEAD><BODY><P>I need to compare a list of string values from an Alternate State list to another list of string values in an alternate state and return values in the alternate state that do not appear in the first list.&nbsp; So, for example...</P><P></P><P></P><P>Alternate State 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Alternate State 2</P><P><SPAN style="text-decoration: underline;">List A</SPAN>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; <SPAN style="text-decoration: underline;">List B</SPAN></P><P>String A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String A</P><P>String B&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String B</P><P>String C&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String C</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; String D</P><P></P><P>The comparison would return "String D".</P><P></P><P>I have been researching Alternate States, but no luck on a resolution so far.</P><P></P><P>Thank you! </P><P>Lisa</P></BODY></HTML> Thu, 11 Jun 2015 18:17:20 GMT https://community.qlik.com/t5/QlikView/Comparing-list-to-Alternate-State-list/m-p/877743#M655552 Anonymous 2015-06-11T18:17:20Z Re: Comparing list to Alternate State list https://community.qlik.com/t5/QlikView/Comparing-list-to-Alternate-State-list/m-p/877744#M655553 <HTML><HEAD></HEAD><BODY><P>not sure why you need to use alternate state but this expression gives you D </P><P><SPAN style="font-size: 10pt; line-height: 1.5em;"><BR /></SPAN></P><P><SPAN style="font-size: 10pt; line-height: 1.5em;">only({&lt;List2 -= {'$(=(concat(List1,chr(39)&amp;','&amp;chr(39))))'} &gt;}List2)</SPAN></P></BODY></HTML> Thu, 11 Jun 2015 21:13:53 GMT https://community.qlik.com/t5/QlikView/Comparing-list-to-Alternate-State-list/m-p/877744#M655553 ramoncova06 2015-06-11T21:13:53Z Re: Comparing list to Alternate State list https://community.qlik.com/t5/QlikView/Comparing-list-to-Alternate-State-list/m-p/877745#M655554 <HTML><HEAD></HEAD><BODY><P>Maybe something like</P><P></P><P>=concat(<STRONG>{[State 2]-[State 1]}</STRONG> DISTINCT [String List],', ')</P></BODY></HTML> Thu, 11 Jun 2015 21:30:28 GMT https://community.qlik.com/t5/QlikView/Comparing-list-to-Alternate-State-list/m-p/877745#M655554 swuehl 2015-06-11T21:30:28Z