5 Replies Latest reply: Feb 27, 2016 7:08 PM by Delzad Dubash RSS

    Creating a Column based on a condition



      I have loaded some columns in Qlik Sense Desktop which are:

      1. "Date",
      2. Description,
      3. "Short Description",
      4. Segment,
      5. "Sub Segment",
      6. "Transaction Value",


      Segment has values like Home and Entertainment.


      I want to create another column where the columns is named "Home" and the values are from Transaction Value IF the Segment contains Home. Hopefully this table makes it clear.


      SegmentTransaction ValueHome (new column)
      Entertainment (new column)
      Home $100$100



      Any help here would be appreciated.