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

    Creating a Column based on a condition

    Delzad Dubash

      Hi,

       

      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
      Entertainment$200$200
      Entertainment$300$300
      Home$400$100

       

       

      Any help here would be appreciated.