Discussion board where members can get started with Qlik Sense.
My data source is in Oracle database and Excel sheet.
The column is as the following:
I need change the text in the myRecording column as the following:
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!
Go to Solution.
Sure you can...
If(Match(myRecording, 'No Recording'), 'NO',
If(WildMatch(myRecording, 'Recording*'), 'Yes', 'Not Applicable')) as myRecordingType
or you can use a mapping load to maintain a more complex list of myRecording options
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!
( if ([myRecording] ='Recording is Good' or [myRecording]='Recording is excellent'or [myRecording]='Recording OK','Yes',
if ([myRecording] ='No Recording', 'No','Not Appliciable') ) ) as myRecordingType,