topic Re: Starting modeling in Qlik in QlikView

Starting modeling in Qlik

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hello

I'm new in Qlik world, I've been working with Oracle BI for years and it took me a while to get used to it. I have a problem with the star model, in Oracle BI I have a sales model with fact table of invoices (with daily sale) and the sales budget (with monthly budget); both fact tables have several dimensions in common; I am currently passing this model to Qlik and according this scenario I have two questions:

1) By relating the dimensions to their corresponding tables, Qlik builds a third object where he assembles the synthetic keys, so what I read in the forums would be fine since that is how qlik works, but there is a way to remove this object and relate the dimensions and the facts directly?

2) As I mentioned I have the daily sale and the monthly budget, each one is related to its respective time dimension, one at day level and another at month level, how can I do to have a single time dimension that groups day and month levels to stablish a relation with sales and budget fact tables?

Thank you for your answer

Re: Starting modeling in Qlik

rupamjyotidas — Tue, 06 Feb 2018 18:18:52 GMT

1) Synthetic keys: read about them and how to remove them.

- Use new field names in Qlik script

- or if the tables can be joined or concatenate. Explore these options too.

2) My Suggestion would be to build a Master Calendar and link both the Calendar table with the Fact Table using DateID

Master Calendar Script

Re: Starting modeling in Qlik

_armoco_ — Wed, 07 Feb 2018 05:18:18 GMT

Hi Paul,

1) Whenever there are more than one key, QlikView will automatically create the Synthetic table. You can get rid of Synthetic keys in many ways:

a) Renaming the field in any one of the table to a different name

b) Using join or concatenate to merge/join the tables

c) Commenting off the unnecessary fields, if any, that forms a key, from any of these tables

d) Using 'Qualify' and 'Unqualify'

e) Using Link tables.

Find out which one is suitable for your data model and use it.

Read this up if possible: https://www.analyticsvidhya.com/blog/2014/11/synthetic-keys-qlikview-simplified/‌

2) Your Daily sale and monthly budget are having different granularity when it comes to date. One is daily data and the other monthly. You can solve this by creating a simple Master Calendar. The master Calendar script has already been shared by rupamjyotidas‌. Just use the same script and change the Date field name to your date field name wherever applicable.

Regards,
Arjun

Re: Starting modeling in Qlik

Anonymous — Tue, 20 Feb 2018 19:22:27 GMT

Hi Arjun, I'll do that.

Thanks for your help

Re: Starting modeling in Qlik

CarmenReilly — Tue, 20 Feb 2018 20:54:50 GMT

Hi Paul,

I hope you're doing well today!

Since you mentioned that you are just getting started with QlikView, you might also find the tutorials and guides available here: https://help.qlik.com/en-US/qlikview/November2017... helpful. You might find the Help Sites - which are the full technical documentation and user guides for the products - handy as well: https://help.qlik.com/en-US/qlikview/November2017... .

Lastly, you can always take a look at our formal training options: QlikView Training: How to Add Business Intelligen...

Just wanted to give you some resources to help get you up and running - glad to have you using Qlik!

All The Best,

Carmen Reilly