Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

¿How to make a calculate field?

Hi dear all,

I have 2 tables:

TABLE 1:

   

TICKETQTYSERVICE
1115Service 1
2224Service 2
3335Service 3
4442Service 4
5557Service 5

TABLE 2:

  

SERVICECOST
Service 1200
Service 2220
Service 3300
Service 4600
Service 5200

EXPECTED TABLE IN QLIKSENSE:

  

TICKETTOTAL COST
1111000
222880
3331500
4441200
5551400

I need to make the red measure in QlikSense.

Thanks in advance.


Tags (3)
1 Reply
MVP
MVP

Re: ¿How to make a calculate field?

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

];

 

Community Browser