topic Data model in QlikView

Data model

deepakqlikview_123 — Mon, 30 Jun 2014 13:19:24 GMT

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

Re: Data model

Anonymous — Mon, 30 Jun 2014 13:21:41 GMT

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

Re: Data model

Mon, 30 Jun 2014 17:12:04 GMT

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.