Discussion board where members can get started with Qlik Sense.
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,
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).
Check the below code,
LOAD * Inline [
LOAD if(Exists(A,B),'',B) as newCheck,A,BResident Table1;
View solution in original post