5 Replies Latest reply: Apr 29, 2018 9:08 AM by Manish Kachhia RSS

    Merging Fields (or) Create the Dimension

    bhuvaneshwaran m

      Dear Expert,

       

      Platform: Qlik Sense

       

      i have a table shown in below.

       

      In that table having 4 different delivery modes. i want to merge the particular delivery mode in a single column.

       

      Like CP+XD+XT = Mode 1 ; XM= Mode 2.

       

      if it’s possible to create the dimension means kindly share the steps.

       

      Dimension 1 = Mode 1

       

      Dimension 2 = Mode 2

       

      Actual Data:

       

      Deli.ModeTotal Count
      CP383911
      XD11970
      XM1591480
      XT1921940
      Grand Total3909301

       

      Condition:

       

      CP+XD+XTMode1
      XMMode2

       

      Output Need Like Below:

       

      Deli.ModeTotal Count
      Mode12317821
      Mode21591480
      Grand Total3909301