topic Calculated measure from two FACT tables in QlikView

Calculated measure from two FACT tables

Fri, 02 Jul 2010 11:11:14 GMT

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

Calculated measure from two FACT tables

Fri, 02 Jul 2010 11:23:25 GMT

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;

Assuming you can join your 2 tables as per your requirements, you can then create a Variable in the Document Properties,
called TestMeasure, and set the expression to =FactTimeregistration.TimeProduction*FactKapacity.TimeRegistered

Calculated measure from two FACT tables

Fri, 02 Jul 2010 11:57:27 GMT

thanks GraemeB, I wasn't aware of this way to do it.