Discussion Board for collaboration on QlikView Scripting.
I believe I have a very simple problem.
I have got two tables and want to calculate sth. with one field of each of them. They are connected by the ID.
Now I want to subtract Days-DaysOff as a new field in Table1.
So I started like this:
left join (Table1) LOAD ID, Days-DaysOff as TotalDays resident Table2;
I also switched Table1 and Table2 but I dont get it. TotalDays should be a field of Table1. In the best case I do not want to JOIN them. I know this would be a solution.
Thanks in advance!
Go to Solution.
You are correct, both fields need to be in Table1 before you can calculate TotalDays. The way to do it is like this
Join (Table1)LOAD ID, DaysOffResident Table2;Join (Table1)LOAD ID, Days - DaysOff As TotalDaysResident Table1;DROP Field DaysOff from Table1;
Days - DaysOff As TotalDays
DROP Field DaysOff from Table1;
Hope that helps
totally what I thought, thanks a lot!