Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Have you read applymap use case? And it allows how many parameters.
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