Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor III
Contributor III

Is it possible to have multiple data models in single QVW application?

Hi ,

Is it possible to have multiple data models in single QVW application? If Yes, What scenarios we will use this.

Is it right thing to create multiple data models in single QVW.

Can you please explain this??

Thanks,

Nagaraju

13 Replies
Highlighted
MVP
MVP

Re: Is it possible to have multiple data models in single QVW application?

Couple of years ago the restriction(that too with Doc CALs only) was there, now you can have multiple data models in a single qvw.

Highlighted
Contributor III
Contributor III

Re: Is it possible to have multiple data models in single QVW application?

Hi tresesco,

Is it good practice to create multiple data models in Qlikview. What scenarios we will create these type of models.

Thanks,

Nagaraju

Highlighted
Specialist II
Specialist II

Re: Is it possible to have multiple data models in single QVW application?

As far as I know, there are limitations regarding the use of Document licenses. If your model moves too far away from the classic star schema (regarding a central fact table and dimension tables with significant smaller amount of distinct values) then it might be, that Document licenses do not work...but I never experienced something like that

Highlighted
Not applicable

Re: Is it possible to have multiple data models in single QVW application?

YES POSSIBLE!

ON SCRIPT EDITOR!

USE SEPARATE TABS FOR EACH DATA MODEL

Highlighted
MVP
MVP

Re: Is it possible to have multiple data models in single QVW application?

In general, it should be avoided, because that could create confusion on front-end behavior (because of un-associated data model) and would be expensive in terms of script maintenance. However, you could face a situation where there would a small set of data that really is not part of main analysis data, in that case you might want to keep that part as a separate model.

Highlighted
MVP
MVP

Re: Is it possible to have multiple data models in single QVW application?

It is tecnical possible but seldom advisable since you can achieve the same effect with document chaining withou the disadvantages. Speed and size will be a challenge for a comprehensive multiple (non-associated) business data models.

Having data islands - one or a few minor tables is not uncommon. Mostly for UI covenience. The bulk data model is the business data model  and should be one associated whole. If you have a problem getting the associations/links correctly it might be a sign that you either should split your app into two separate apps or spend even more time on your data modelling.

When it comes to the license terms a customer is specifically not allowed to have two or more business data models (larger) side-by-side with the Small Busines Edition of the  server.

Highlighted
MVP
MVP

Re: Is it possible to have multiple data models in single QVW application?

Tabs will never separate your data model - tabs are purely a UI covenience

Highlighted
MVP
MVP

Re: Is it possible to have multiple data models in single QVW application?

Well is is possible ... but may not be desirable. You will have to design the model carefully to properly handle multiple fact tables with varying granularity and avoid undesirable circular loops and synthetic keys. You may land up with having duplicate copies of the dimension tables, which will be confusing for the users and it is more complex to encode expressions.

One of the great features of QV is its modular nature, and you lose many benefits of that if you try do to much in a single qvw file.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Highlighted
Champion
Champion

Re: Is it possible to have multiple data models in single QVW application?

Hi,

excuse me if this is a stupid question - but what exactly is the factor toggling whether to speak of one or of several data_models in a QlikView_app?

I know that several tables, which are usually linked in some way or other, form a data_model, of course. But:

Is every table that is not linked to any other a separate data_model? Then I have up to 6 or so in some apps.

If it may be that at some point, a Document_license stops working, then I guess it is relevant - I never had any issues with that up to now.

Or maybe everything starting from 2 linked tables?

Thanks a lot!

Best regards,

DataNibbler