Columns compare

[Mahamed_Qlik]

Hi

As you can see picture below, I want to compare these two column values either on set analysis or in back end script.

[VatsalyaSolanki]

Hey @Mahamed_Qlik ,

Could you be more specific like what do you want to achieve by comparing those Fields.

[Mahamed_Qlik]

Ok. Diagram itself is explanatory however I will make it more clear.

We have 4 tables....

Table1 and Table2 we are connecting based on one key column named as Key1,

similar Table 1 and Table3 are connecting based on Key3 and Table2 and Table 4 are connecting based on Key4.

Now, we have price column in Table 1 for which we need to write expression as -

Sum (Price) where ID =ID...so for this reason we want to compare ID1 and ID2 from both table 

[VatsalyaSolanki]

Try This

Sum({$<ID1={"=ID1=ID2"}>}Price)

Or

Sum({$<ID1=P(ID2)>}Price)