Dear Qlik Community,
I have return a code, the same as below,
=Pick(Match(ValueList('Cycle Time - Man s','Cycle Time - Machine s','JPH - Man N','JPH - Machine N','Make Special Characteristic %','FTQ - Process defect %','Scrap %','OEE %','Number of Operators used N','Make Component Packaging N','Production Operator Skills %','SOS, SOP, JES, OPL process standard %','Maintenance Operators training %','Preparation spare parts %')
,'Cycle Time - Man s','Cycle Time - Machine s','JPH - Man N','JPH - Machine N','Make Special Characteristic %','FTQ - Process defect %','Scrap %','OEE %','Number of Operators used N','Make Component Packaging N','Production Operator Skills %','SOS, SOP, JES, OPL process standard %','Maintenance Operators training %','Preparation spare parts %')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[Cycle Time - Man [s]]_MFG_Target]),'#,##0;-#,##0')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[Cycle Time - Machine [s]]_MFG_Target]),'#,##0;-#,##0')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[JPH - Man [N]]_MFG_Target]),'#,##0;-#,##0')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[JPH - Machine [N]]_MFG_Target]),'#,##0;-#,##0')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[Make Special Characteristic [%]]_MFG_Target])/100,'##0.0%;-##0.0%')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[FTQ - Process defect [%]]_MFG_Target])/100,'##0.0%;-##0.0%')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[Scrap [%]]_MFG_Target])/100,'##0.0%;-##0.0%')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[OEE [%]]_MFG_Target])/100,'##0.0%;-##0.0%')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[Number of Operators used [N]]_MFG_Target]),'#,##0;-#,##0')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[Make Component Packaging [N]]_MFG_Target]),'#,##0;-#,##0')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[Production Operator Skills [%]]_MFG_Target])/100,'##0.0%;-##0.0%')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[SOS, SOP, JES, OPL process standard [%]]_MFG_Target])/100,'##0.0%;-##0.0%')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[Maintenance Operators training [%]]_MFG_Target])/100,'##0.0%;-##0.0%')
,Num(Max({$<HISTORY_MFG_Target={"$(=Max({$<status_MFG_Target={'PT'}>}HISTORY_MFG_Target))"}>}[Preparation spare parts [%]]_MFG_Target])/100,'##0.0%;-##0.0%')
)
The system gives an error message. It looks like a complex one, but it is not.
Can someone tell me if there is a syntax error in the above expression?
Thanks,
A.S
