Discussion board where members can learn more about Qlik Sense App Development and Usage.
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?
Please see the link below on LinkTables
I hope it helps,
Link Table in QlikView – Learn QlikView
View solution in original post
I've also used this one from Fabrice Aunez
I hope it helps
Perfect... Just what I needed!
So can we say that link table architecture is a Star Schema ?