Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.


Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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!


2 Replies
Not applicable

Re: Comparing list to Alternate State list

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

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

Not applicable

Re: Comparing list to Alternate State list

Maybe something like

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