topic Re: Match two columns by values not by rows in QlikView

Match two columns by values not by rows

Thu, 08 Oct 2015 04:27:27 GMT

How to match two columns by values and display matching values in another seperatega column and nonmatching of inside these columns separately. E.g

Column1. Column2

1. 3

2. 1

4. 6

5. 5

8. 3

Expected Result:

Column1.Column2.Column3(match).Column4(nonmatchedvaluesofcolumn1).Column5(..col2)

.... ..... 1. 2 6

3. 4

5. 8

malini_qlikview — Thu, 08 Oct 2015 10:12:07 GMT

Hi,

You can use exists and Not exists function to achieve this,

Pls find attached

Fri, 09 Oct 2015 02:56:21 GMT

Thanks, please post the script.

Tue, 13 Oct 2015 15:17:13 GMT

If(exists(col1,col2), col2) as unmatchcol1.

If(exists(col2,col1),col1) as unmatchcol2.

These are correct? If not can you post script for the three columns including match col.

Wed, 14 Oct 2015 01:19:10 GMT

I did individually,

Col2

Where not exists(col1,col2)