Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

field value comparision

I just want to know is there any possibilities to check the particular field's each value by the other fields value(one by one).

what I try to convey is,

for ex: now I have two fields,

A   B

3   4

4  3

5  2

2   5     

Now, each Value of A should go and check with each value of b (3(1st val of A) should go and check with every value of B).

Through this, I'll create the next Field 'C' (if the

value of A=Value Of B, then it should not come in the field C).

 

Thanks ,

Ajith

 

1 Solution

Accepted Solutions
Highlighted
Specialist
Specialist

Re: field value comparision

Hi Ajit,

Check the below code,

Table1:

LOAD * Inline [

A, B

10, 10

2, 20

3, 30

];

Table2:

LOAD if(Exists(A,B),'',B) as newCheck,A,B
Resident Table1;

Rgds,

Shubham

View solution in original post

1 Reply
Highlighted
Specialist
Specialist

Re: field value comparision

Hi Ajit,

Check the below code,

Table1:

LOAD * Inline [

A, B

10, 10

2, 20

3, 30

];

Table2:

LOAD if(Exists(A,B),'',B) as newCheck,A,B
Resident Table1;

Rgds,

Shubham

View solution in original post