Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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

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.