Discussion Board for collaboration on QlikView Scripting.
At the end of my script I want to recalculate the [Exp hrs].
In one LOAD-statement I'm adding the fields [%Date], [Actual Hours], [Exp hrs] and [Calculation Method] to [MyTable]
I'm using a JOIN to add the field [Target Prod]
Now depending on the Calculation Method the Expected hours need to be recalculated.
My join doesn't recalculate all the records in [MyTable]
// use calculation method to recalculate [Exp hrs]
LEFT JOIN ([MyTable])
LOAD If ([Calculation Method]=2,
IF ([Actual Hours]>0, [Target Prod],
as [Exp Hours]
Drop Fields [Exp hrs];
Can anyone tell me how I'm supposed to recalculate all records?
Go to Solution.
If ([Calculation Method]=2,
Drop table MyTable
I think you'll need at least one identifying column to match the row for the join:
LEFT JOIN (MyTable)
LOAD ID, <Expression> as Exp
Why Join: if this is a large fact table it could have serious memory implications..