Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

datalakeyu
Valued Contributor

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

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!

1 Solution

Accepted Solutions
MVP
MVP

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

Sure you can...

LOAD myRecording,

          If(Match(myRecording, 'No Recording'), 'NO',

          If(WildMatch(myRecording, 'Recording*'), 'Yes', 'Not Applicable')) as myRecordingType

FROM ...

or you can use a mapping load to maintain a more complex list of myRecording options

2 Replies
MVP
MVP

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

Sure you can...

LOAD myRecording,

          If(Match(myRecording, 'No Recording'), 'NO',

          If(WildMatch(myRecording, 'Recording*'), 'Yes', 'Not Applicable')) as myRecordingType

FROM ...

or you can use a mapping load to maintain a more complex list of myRecording options

datalakeyu
Valued Contributor

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

Hi Sunny , thanks so much for your help!
I just figured out a solution. Your method is better than mine.
The following is my method.
Thanks again!

LOAD

    ( if ([myRecording] ='Recording is Good' or [myRecording]='Recording is excellent'or [myRecording]='Recording OK','Yes',

          if ([myRecording] ='No Recording', 'No','Not Appliciable')
        )
    ) as myRecordingType,

Community Browser