Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
];