4 Replies Latest reply: Oct 26, 2017 10:21 AM by JEFF TURNBULL RSS

    Qliksense Question  If then and Date return

    JEFF TURNBULL

      I have a table containing a  Product Code , a Transaction Type and Date associated with the Transaction Type. There could be multiple Instances of the Transaction Type by date.

       

      Example:-   

      Product Code DateTransaction Type
      000101/10/2017ADJ
      000129/09/2017ADJ
      000127/09/2017RECP
      000115/09/2017RECP

       

      I want to  return the latest RECP Date i.e. 27/09/2017 but, if there is no RECP then return the latest ADJ. 01/10/2017

       

      How can I achieve this in a IF THEN statement