topic Apply map not working with where clause in QlikView

Apply map not working with where clause

Anonymous — Tue, 26 Jun 2018 16:26:07 GMT

Can some tell me why this wont work

BudgetMap:

Mapping load

,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 — Wed, 27 Jun 2018 01:55:45 GMT

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

marcus_sommer — Wed, 27 Jun 2018 10:31:17 GMT

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