If statement error

[nbuscemi]

Can someone tell me which the problem is here?

=if(CATEGORY_EXPENSE = 'VARIABLE COST NVS', 'Variable Costs' & ': ' & sum( {<CATEGORY_EXPENSE = {*} - {"COST AVOIDANCE"} - {"INTERNAL COST NVS"} - {"TRIAL LOGISTICS COST"}>} AMOUNT)),

if(CATEGORY_EXPENSE = 'INTERNAL COST NVS', 'Internal Costs' & ': ' & sum( {<CATEGORY_EXPENSE = {*} - {"COST AVOIDANCE"} - {"VARIABLE COST NVS"} - {"TRIAL LOGISTICS COST"}>} AMOUNT)),

if(CATEGORY_EXPENSE = 'TRIAL LOGISTICS COST', 'Trial Logistics Costs' & ': ' & sum( {<CATEGORY_EXPENSE = {*} - {"COST AVOIDANCE"} - {"INTERNAL COST NVS"} - {"VARIABLE COST NVS"}>} AMOUNT))

Qlik Sense says

garbage after expression: ','

[NitinK7 · Accepted solution]

Hi

Try below Expression

=IF(CATEGORY_EXPENSE='VARIABLE COST NVS','Variable Cost' &' :'& Sum({<CATEGORY_EXPENSE-={'COST AVOIDANCE','INTERNAL COST NVS','TRIAL LOGISTICS COST'}>}AMOUNT),

IF(CATEGORY_EXPENSE='INTERNAL COST NVS','Internal Cost' &' :'& Sum({<CATEGORY_EXPENSE-={'COST AVOIDANCE','VARIABLE COST NVS','TRIAL LOGISTICS COST'}>}AMOUNT),

IF(CATEGORY_EXPENSE='TRIAL LOGISTICS COST','Trial Logistics Cost' &' :'& Sum({<CATEGORY_EXPENSE-={'COST AVOIDANCE','INTERNAL COST NVS','VARIABLE COST NVS'}>}AMOUNT)

)))