Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Difference of two fields containing characters

I have two fields as below

Field 1

A

B
C
D
E
F
G
H
Field 2

A

B
D
E
G

I want my output to be

Output
C
F
H

i.e. the values which are not common between Field 1 and Field 2. How can i do it using expressions in a list box.

I have attached a sample file for the same.

Regards,

Sumit

3 Replies
Carlos_Reyes
Partner - Specialist
Partner - Specialist

See the attached qvw

Not applicable
Author

Thanks for the reply Carlos but i have one more concern. My filed is not just Field1, i use some calculations to get the values. This was just an example. It is something like

Field1=

Concat

({<Month_MMM=,Year=,Quarter=>}if(aggr(Concat(DISTINCT {1<[Run Date]={$(vBaseMonth)},EmployeeType={'Employee'}>}Active_Name)
-Concat(DISTINCT {1<[Run Date]={$(vCompareMonth)},EmployeeType={'Employee'}>}Active_Name),Active_Name,[DEPT_Lv3])=-1,1,0))
-Concat(DISTINCT {<[Run Date]={$(vCompareMonth)} ,EmployeeType={'Employee'} ,min_emp_date={'>$(vBaseMonth)'},Month_MMM=>}Active_Name)


Not sure how to use it

Carlos_Reyes
Partner - Specialist
Partner - Specialist

What are you trying to do with that expression?

If you elaborate your requirement a little bit more and provide sample data or app it'll be easier to help you.