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]
