Discussion Board for collaboration on QlikView Scripting.
I have two values like x from A table and y from B table.
I want to create a Table by taking difference of x an y.
assuming there is a common field you can define:
left join (tmptest)
x-y as diff
drop table tmptest
hope that helps
This can be possible with Resident load, please see below yon do something like that :
Resident load is like this.
select columna, value, columnb
select columna, sum(value)
group by columna;
Getting error after resident A. not able to use left join.
PremiumOGIS Resident OGIS
Try like this
left join (Temp)
drop table Temp
Hope this helps you.
please post sample data of both tables
I suggest to make a mpaping from one table and then use an applymap to the sencond.
Mapping Load key,
(applymap('Map_Table',key,Null()) - y) as Diference