topic Columns compare in App Development

Columns compare

Mahamed_Qlik — Thu, 21 Sep 2023 05:19:13 GMT

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

VatsalyaSolanki — Thu, 21 Sep 2023 06:01:22 GMT

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

Mahamed_Qlik — Thu, 21 Sep 2023 07:34:50 GMT

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 — Thu, 21 Sep 2023 07:38:17 GMT

Try This

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

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