Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Comparing list to Alternate State list

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.  So, for example...

Alternate State 1                    Alternate State 2

List A                                       List B

String A                                   String A

String B                                   String B

String C                                   String C

                                                String D

The comparison would return "String D".

I have been researching Alternate States, but no luck on a resolution so far.

Thank you!

Lisa

2 Replies
ramoncova06
Specialist III
Specialist III

not sure why you need to use alternate state but this expression gives you D


only({<List2 -= {'$(=(concat(List1,chr(39)&','&chr(39))))'} >}List2)

swuehl
MVP
MVP

Maybe something like

=concat({[State 2]-[State 1]} DISTINCT [String List],', ')