Discussion Board for collaboration on QlikView Scripting.
Hi All,I'll appreciate your assistance on the issue I have as described below:
Contains the first 4 columns - I would like to add a new filed (Potential_Left) with the calculated data as shown below
I'll appreciate your advise.
Product_Potential - NumSum(Previous(Potential_Left), Production) AS Potential_Left
I think it could look like
if(isnull(peek(Potential_Left)),Product_Potential,peek(Potential_Left))-Production as Potential_Left,
maybe including a check for Warehouse in the if() statement and using an appropriate order of your records.
Hi Stefan,can you attach the scripting you think should matxh here? I also want to care the case we have an additional warehouse (B, C etc).Thanks,David
I think it could look like (if your table existing table is labelled TMP):
LOAD Warehouse, Product_Potential, WorkOrder, Production,
if(peek(Warehouse)=Warehouse,peek(Potential_Left), Product_Potential) - Production as Potential_Left
resident TMP order by Warehouse, WorkOrder;
drop table TMP;