Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am quite new in Qlikview and need a little help:
I am making Qlikview dashboards on a Datawarehouse and need to make a calculated measure with measures from 2 FACT-tables.
Example:
I need to make a calculated measure:
TimeProduction*TimeRegistered as TestMeasure
from the following FACT_tables:
SQL SELECT
DepartmentKey
, CustomerKey
, EmployeeKey
, ProjektKey
, TimeProduction
FROM Datawarehouse.dbo.FactTimeregistration;
CONCATENATE SQL SELECT
, CustomerKey
, EmployeeKey
, ProjektKey
, TimeRegistered
FROM Datawarehouse.dbo.FactKapacity;
please advise.
BR,
Jakob
I'd load the two tables separately from the SQL database.
FactTimeregistration:
Load DepartmentKey,
CustomerKey, EmployeeKey, ProjektKey,
TimeProduction;
SQL SELECT *
FROM Datawarehouse.dbo.FactTimeregistration;
FactKapacity:
LOAD CustomerKey
, EmployeeKey
, ProjektKey
, TimeRegistered;
SQL SELECT *
FROM Datawarehouse.dbo.FactKapacity;
thanks GraemeB, I wasn't aware of this way to do it.