2 Replies Latest reply: May 28, 2018 6:28 AM by baptiste genin RSS

    How To : get a value in a field according to values in other fields

    baptiste genin

      Hi everyone,

       

      I'm trying to find a way to create a field from data located in other fields.

      Basicly, form the table below, How can i find the latest value for the item 1 if the message is B.

       

      The result should be 10.

       

      DateID itemMessageValue
      25-mai1B10
      24-mai1A5
      23-mai1B3
      22-mai1B7
      21-mai2A1
      20-mai2A7
      19-mai2C6

       

      For information, this operation is done in the script. All the values found are then put together in a field in order to easily find them in qlik sense when a ID item is called.

       

      Thank you for your time,

       

      Baptiste