Discussion board where members can get started with Qlik Sense.
I'm loading a Table and based on the informations I have in the field 'comment' I would like to build a new field Status.
if(comment like '*Test*', 'Test',
if(comment like '*Blocked*', 'Blocked',
if(comment NOT LIKE '*check*' and NOT LIKE '*analyse*', 'To be checked',
if(comment like ......)))) AS Status
Thanks for your help
Solved! Go to Solution.