Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

micheledenardi
Valued Contributor

Load Expression from excel and use them during load

Hi guys,

i have two tables structured as below:

MAPPING_TABLE:

MapKeyMapFormula
aField1+Field2+Field3
bField1+Field2+Field3
cField1+Field2+Field3
dField1+Field2+Field3

FACT_TABLE:

KeyField1Field2Field3
a111
b222
c333
d444

and i would like to use the declared formulas on this mapping table to obtain resulst on another table...so:

MAPPING_TABLE:

Mapping

Load

     MapKey,

     MapFormula

From MAPPING_TABLE.xls;

FACT_TABLE:
Load

     Key,

     Field1,

     Field2,

     Field3,

     Applymap('MAPPING_TABLE',Key) as Result

From FACT_TABLE.qvd(qvd);

but the resut is

KeyResult
aField1+Field2+Field3
bField1+Field2+Field3
cField1+Field2+Field3
dField1+Field2+Field3

and i would like to obtain:

KeyResult
a3
b6
c9
d12

Any idea ?

3 Replies
joshrussin
Contributor II

Re: Load Expression from excel and use them during load

Are you trying to obtain a cumulative field from the mapping table?

joshrussin
Contributor II

Re: Load Expression from excel and use them during load

look at these examples using just the data table, see if these help

micheledenardi
Valued Contributor

Re: Load Expression from excel and use them during load

No,

i don't want to obtain a cumulative result.

I want to specify a formula (Ex. sum(Field1+Field2+Field3)) on the mapping table and then use applymap() to calculate the result of the formula by using the Field1, Field2, Field3 of my final table.