Apply map not working with where clause

[Anonymous]

Can some tell me why this wont work

BudgetMap:

Mapping load

ID

,num(value1,value1) as value2

From [lib:qvd/budget.qvd](qvd) where KPI ='OCF';

Load *

,num(applymap('BudgetMap',ID,null(),value1) as value2

From [lib:qvd/budget.qvd](qvd) where KPI ='Revenue';

Value 2 returns no data. I just want to add an addtional column to the revenue KPI filter that contains the value from the OCF filter.

They contain idential data but the data in the value1 field is different when filtered by KPIs.

[Anil_Babu_Samineni]

Have you read applymap use case? And it allows how many parameters.

[marcus_sommer]

Your expressions have a wrong syntax. Try it in this way:

BudgetMap:

Mapping load ID, value1

From [lib:qvd/budget.qvd] (qvd) where KPI ='OCF';

Load *, num(applymap('BudgetMap',ID,null()) as value2

From [lib:qvd/budget.qvd] (qvd) where KPI ='Revenue';

- Marcus