13 Replies Latest reply: Dec 5, 2017 6:47 PM by Luis Madriz RSS

    return the value that matched the category.

    Isabel Encinas

      Hi Everyone,

       

      I'm really new in Qlik. would like to return the data with the below conditions.

      I have attached the data with 2 tabs:

       

      1. sample data

      2. desired result

       

      Condition:
      Return CLI for 1st Participant "customer" Purpose INBOUND Direction
      Return CLI for "customer" Participant Purpose OUTBOUND Direction

       

      luismadriz thanks!