topic Re: Difference of two fields containing characters in QlikView

Difference of two fields containing characters

Wed, 06 Nov 2013 23:18:48 GMT

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

Re: Difference of two fields containing characters

Carlos_Reyes — Wed, 06 Nov 2013 23:39:06 GMT

See the attached qvw

Re: Difference of two fields containing characters

Wed, 06 Nov 2013 23:52:09 GMT

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

Re: Difference of two fields containing characters

Carlos_Reyes — Wed, 06 Nov 2013 23:58:01 GMT

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.