Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
See the attached qvw
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
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.