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

[nagarajupinnibo]

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

[danieloberbilli]

Regarding Document license...I got this from the server manual:

quote start

The Document CAL can only be used with documents that have a single contiguous data model and do not contain any chasm traps between tables. Most common data models used in QlikView documents can be used for Document CALs. For instance, proper star schemas and snowflake schemas typically have the field with the highest cardinality in the fact table and the keys in dimensional tables have a lower cardinality. For snowflake schemas, the cardinality decreases further when moving away from the fact table. Documents containing such models typically fulfill the above demands and are well-suited for Document CALs. Documents with multiple logical islands are normally not allowed. Multiple logical islands are only allowed, if the additional tables are unconnected and contain only few records or a single column.

In addition, the document may not contain any loosely coupled tables.

Finally, the cardinality (that is, the number of distinct values) of the key fields must decrease when moving away from the fact table.

quote end

[datanibbler]

Hi Daniel,

that sounds a bit complicated 😉 Honestly, I doubt that Qlik have really implemented in their licenses a check for that about the cardinality of the key_fields ... usually, that is the case, but it's not something you really ought to care for, is it?

Well, logical islands are seemingly not a problem - I have those just about everywhere and I guess others have them, too. Multiple ones, too. Maybe if those were connected, they would establish a second data_model which might be a problem.

Does anyone know this for sure? Has anyone ever actually reached a point where a Document_license does not work anymore?

[danieloberbilli]

I agree...I tested already some pretty 'messy' models and never had a problem

[#5]

Really useful question, and some great answers, thanks all.