3 Replies Latest reply: Jan 26, 2016 1:48 AM by Marcus Sommer RSS

    Peek function in the script - how flexible is it?

    John Blomqvist

      Hi,

       

      Can anybody tell me how flexible is the script function in the script?

       

      It seems to behave differently compared to some QlikView rules for fields.

       

      For example if I create a calculated field, I can refer that field back into the same calculated field.

       

      E.g.

      Load

      Product,

      Value

      If(RecNo()=1, Amount,If(Product=Peek(Product), Value + Peek(AboveTotal),Value)) as AboveTotal

      Resident Table

       

      I never knew this was possible with peek.