Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

prashanth1712
New Contributor III

Need help on Datamodel

hi team,

In my qliksence application i have around 80 tables.basically this is a conversion project what ever they implemented in their tool we need to implement the same here but the problem is the tables having huge like 17cr records in almost 30 tables among that 15 table are not having anydatefileld and filters.if i load the data app size is exceeding 250mb .so please help me out how to create the data model.

NOTE:

In my fact table i have date field as a filter

and also few tables are having more than 5 date fileds

Thanks

Prashanth

1 Reply
MVP
MVP

Re: Need help on Datamodel

With the information provided, I can only make overall recommendations. 80 tables is a lot. The most complex model I have built has about 20 tables (including island tables for dimensions and control purposes) and this was integrating data from about 25 different sources. Having said that, 3 million rows and 250 MB is not a very large data set.

You need to work towards a star structure with a single central fact table and dimension tables linked to the fact table. You could also collapse small dimensions (eg containing only some ID/Name data) into the fact to simplify the structure.

Have a look here for more help:

Get started with developing qlik datamodels

Advanced topics for creating a qlik datamodel

More advanced topics of qlik datamodels

For more detailed help, you will get better responses if you supply more information and ask a more specific question.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Community Browser