Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kashjaniqlik
New Contributor III

Calculating measures from two dimension tables in a Fact table

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.

2 Replies
kashjaniqlik
New Contributor III

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

Please ignore the label. Not answered yet.

qliksus
Valued Contributor

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

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

Community Browser