2 Replies Latest reply: Jul 6, 2016 1:14 PM by Haikuo Yu RSS

    Is it possible to create a new text column with "Add a calculated column" in Qlik sense?

    Haikuo Yu

      My data source is in Oracle database and Excel sheet.

      The column is as the following:


      myRecording
      No Recording
      No Recording
      Recording is Good
      Recording is excellent
      Recording OK
      No Information
      No Information

       

      I need change the text in the myRecording column as the following:

        

      myRecordingmyRecordingType
      No RecordingNO
      No RecordingNO
      Recording is GoodYes
      Recording is excellentYes
      Recording OKYes
      No InformationNot Appliciable
      No InformationNot Appliciable

       

      Is it possible to use 'Add a calculated column' in Qlik sense to get the new column 'myRecordingType'? Also, I need load the data from Oracle database and Excel file.

      Any suggestion is appreciated!