Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ijcornish
Contributor II
Contributor II

Sense - Multiple Fact tables...

I've read a number of excellent articles on this site about this but am still confused... I'm working on a QlikSense project for Sales/order/budget analysis.

I have 2 Dimensions - Time (with Month & day dimensions) and also Product & Product Group (I can easily flatten these 2 into 1 dimension).

I have 4 Facts- 1) Invoiced Sales (Day level) (at Customer, Country, Product and Currency)

2) Open Orders (Day level) (ie not in the Invoiced Sales fact) (at Customer, Country, and Product)

3) Budget (Month level)(at Country, Product and Currency)

4) Forecast (Month level) (at Country, Product Group and Currency)

So, I need to create a Master table of Time (Day & Month), Product, Customer, Country, Currency with three different generated keys (for each Fact). HOW?!?!?!

My first thought was to Load the Time Dimension and Product dimension as a cartesian product from SQL (limited to current year/product). However, this sounds like "Kill the server" territory

I've looked at Mapping and ApplyMaps, but am confused by them... Can someone clarify and provide a best direction forwards?

Drawing1.jpg

1 Solution

Accepted Solutions
luismadriz
Specialist
Specialist

Hi Ian,

Please see the link below on LinkTables

I hope it helps,

Link Table in QlikView – Learn QlikView

Cheers,

Luis

View solution in original post

4 Replies
luismadriz
Specialist
Specialist

Hi Ian,

Please see the link below on LinkTables

I hope it helps,

Link Table in QlikView – Learn QlikView

Cheers,

Luis

luismadriz
Specialist
Specialist

I've also used this one from Fabrice Aunez

I hope it helps

Cheers,

Luis

ijcornish
Contributor II
Contributor II
Author

Perfect... Just what I needed!

Shubham_D
Partner - Creator
Partner - Creator

So can we say that link table architecture is a Star Schema ?