Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi dear all,
I have 2 tables:
TABLE 1:
TABLE 2:
EXPECTED TABLE IN QLIKSENSE:
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