2 Replies Latest reply: Aug 31, 2013 4:08 AM by Henric Cronström RSS

    Qlikview Script ignores condition

      Hello,

       

      I have the following table:

      [PartCostsCalulation2]:
      NoConcatenate LOAD
        [KeyPart],
        [CostDate],
        if(isNull([TotalCostsEndOfMonth]),
             if([KeyPart]=previous([KeyPart]), 
                  Peek([TotalCostsEndOfMonth]), 0),[TotalCostsEndOfMonth]) as [TotalCostsEndOfMonth],     
        [EndOfMonthStockCalculation]
      Resident [PartCostsCalculation1]
      ORDER BY [KeyPart], [CostDate] ASC;
      DROP TABLE [PartCostsCalculation1];
      

       

      The result should only peek the costs of the previous month if the [KeyPart] (article name) equals the previous record right?

       

      Well, thats not the case. In the resulting table the record just copies the TotalCostsEndOfMonth of the previous KeyPart, even if this KeyPart is different.