topic Re: Calculating measures from two dimension tables in a Fact table in QlikView

Calculating measures from two dimension tables in a Fact table

kashjaniqlik — Mon, 04 Jul 2016 11:37:19 GMT

Hello

I have two dimension tables (say Dim A and Dim B) and a fact table (say Fact). Both dimension tables are linked through it's own keys.

There is another look-up table that is used to filter the data on the fact table. (For e.g. Region and country to filter country specific data)

The data is filtered nicely on Dim A measures although not on Dim B and I'm sure I'm missing something in the FACT table Load.

Unfortuantely, I won't be able to upload any qvw or show any fields due to data security reasons, but has anyone built a fact table with measures from multiple tables linked to a look-up table so that this look up table can filter data on both measures.

Many Thanks for your help.

Re: Calculating measures from two dimension tables in a Fact table

kashjaniqlik — Mon, 04 Jul 2016 16:50:05 GMT

Please ignore the label. Not answered yet.

Re: Calculating measures from two dimension tables in a Fact table

qliksus — Thu, 07 Jul 2016 10:08:56 GMT

Not sure I have understood you correctly but do you want a common filter to be applied to multiple fact table through a look up table ?

Lookuptable:

load filter

From Lkup ;

Fact1:

load * from Fact

where exists(Col1,Fact1.Col);

Fact2:

load * from Fact

where exists(Col1,Fact2.Col);

This wouldn't disturb the join between the fact tables but will apply common filter based on the lookup table