¿How to make a calculate field?

[#1]

Hi dear all,

I have 2 tables:

TABLE 1:

TICKET	QTY	SERVICE
111	5	Service 1
222	4	Service 2
333	5	Service 3
444	2	Service 4
555	7	Service 5

TABLE 2:

SERVICE	COST
Service 1	200
Service 2	220
Service 3	300
Service 4	600
Service 5	200

EXPECTED TABLE IN QLIKSENSE:

TICKET	TOTAL COST
111	1000
222	880
333	1500
444	1200
555	1400

I need to make the red measure in QlikSense.

Thanks in advance.

[maxgro]

in script

TABLE2:

Mapping load * inline [

SERVICE, COST

Service 1, 200

Service 2, 220

Service 3, 300

Service 4, 600

Service 5, 200

];

TABLE1:

load *, QTY * ApplyMap('TABLE2', SERVICE) as [TOTAL COST] Inline [

TICKET, QTY, SERVICE

111, 5, Service 1

222, 4, Service 2

333, 5, Service 3

444, 2, Service 4

555, 7, Service 5

];