topic Subtract two fields values from two different tables in QlikView

Subtract two fields values from two different tables

seband_fredes — Sat, 16 Nov 2024 18:00:15 GMT

Hi everyone, I've two tables:

T1:

T2:

I need to apply an JOIN and subtract Cash fields value between T1 and T2. The join Table's result is:

Any idea?.

Thans for all, blessings

Re: Subtract two fields values from two different tables

dplr-rn — Wed, 07 Oct 2020 18:38:29 GMT

Something like below

T1Temp: load Eq ,Region ,Cash as Casht1 from T1Source; left join(T1Temp) load Eq ,Region ,Cash as CashT2 from T2Source; load Eq ,Region ,Casht1-CashT2 as Cash resident T1Temp; drop table T1Temp;