Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vvvvvvizard
Partner - Specialist
Partner - Specialist

Data model

Good day

Attached is a pic of the data model

The model is accurate

Its not too slow , a little , no one is complaining yet

its 14GB in size

One fact table and the rest are dimension tables

I want to follow data modelling best practices , should i combine the dimension tables together

Getting to the star schema from here is easier said than done , any tips ?

1 Solution

Accepted Solutions
micheledenardi
Specialist II
Specialist II

I think you can use Document Analyzer V3.0 Update Available to check if all the dimensions are used at layout level and drop the unused fields.

After that you have to join() and applymap() your tables (where possible).

Yes, easier said than done.

Check also this link and the attached files.

https://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.

View solution in original post

4 Replies
micheledenardi
Specialist II
Specialist II

I think you can use Document Analyzer V3.0 Update Available to check if all the dimensions are used at layout level and drop the unused fields.

After that you have to join() and applymap() your tables (where possible).

Yes, easier said than done.

Check also this link and the attached files.

https://www.quickintelligence.co.uk/perfect-your-qlikview-data-model/

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
Sergey_Shuklin
Specialist
Specialist

Hello!

If you want to make some cleanings so for the start it can be:

1. Order this chaos! Sort tables by meanings and theme, by links and key fields;

2. Join all that can be joined without changing on cheksum;

3. There can be some trash tables without any help in front-end (and they can be dropped in the script).

As the finish model it should be a fact table with multiple dictionaries.

vvvvvvizard
Partner - Specialist
Partner - Specialist
Author

last question , when can two tables not be joined . Some tables i joined i got incorrect results in front end , so i tried different combinations left , outer , inner , concateneate  which is making me think some tables just cant be joined , is this true ?or can all tables be joined in some way

Sergey_Shuklin
Specialist
Specialist

You should be careful with joining and not all tables can be joined without data corruption.

If it happens, so may be there is a way to transform, separate or combine this table somehow.

This is individual for every model.

Try to make it step by step.