Creating new field based on another field values with multiple If conditions

Anonymous — Wed, 21 Nov 2018 19:50:34 GMT

Hello Qlik Community,

I am trying to create new field called "workstream" with values OT, BAS, AT, PT, Sec, MD based on the field "ParameterValue_1". I am getting error saying that" workstream" field is unavialble on my dashboard . Help me out with following script. Thank you.

If( [ParameterValue_1]='Category:ED' AND [ParameterValue_1]='Category:Sales and Distribution','OT',

If([ParameterValue_1]= 'Category:GR' AND [ParameterValue_1]= 'Category:SA BASIS' AND [ParameterValue_1]='Category:Solution Manager', 'BAS',

If([ParameterValue_1]= 'Category:Finance and Controlling', 'AT',

If([ParameterValue_1]= 'Category:Manufacturing & Controlling' AND [ParameterValue_1]= 'Category:Materials Management' AND [ParameterValue]= 'Category:Plant Main' AND [ParameterValue_1]= 'Category:Production Plan' AND [ParameterValue_1]= 'Category:Quality' AND [ParameterValue_1]= 'Category:Enterprise Data ' AND [ParameterValue_1]= 'Category:Warehouse Management' AND [ParameterValue_1]= 'Subprocess:Plant Maintenance', 'PT',

if ( [ParameterValue_1]= 'Category:Security','Sec',

If([ParameterValue_1]= 'Category:Master Data Management' AND [ParameterValue_1]= 'Subprocess:Master Data Management', 'MD'

)))))) as [workstream]

Re: Creating new field based on another field values with multiple If conditions

Frank_Hartmann — Wed, 21 Nov 2018 19:29:59 GMT

can u please show your whole script?

Re: Creating new field based on another field values with multiple If conditions

Anonymous — Wed, 21 Nov 2018 19:51:22 GMT

Please see below attached script

topic Creating new field based on another field values with multiple If conditions in QlikView

Creating new field based on another field values with multiple If conditions

Re: Creating new field based on another field values with multiple If conditions

Re: Creating new field based on another field values with multiple If conditions