Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
deepakqlikview_123
Specialist
Specialist

Data model

Hello Team,

Please find attachment.

Currently I am merging 2 QVW file into 1 QVW file.Though some of tables are same but it seems too complex.

It is also giving problem while opening newly created QVW file.So i am opening it by using without dataload option.

Can you please suggest what to do in this case.

Thanks,

Deepak

Labels (1)
2 Replies
Anonymous
Not applicable

that is a complex data model! 1st thing i would do is to try building a star schema.

Not applicable

First of all you should try to denormalize this schema, you have a country table with just the CountryID and the Country you should consider adding it to the organization table directly by Country. You should do it with a lot of tables in your model because they are not adding any important data.

As less tables you have the easier to manage the schema.

I know that it is against to all the relational DB theory, but it is the best way to work with qlikview.