Qlik Community

QlikView Documents

Documents for QlikView related information.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

QvM - Dynamic Data Model

cheburashka
Not applicable

QvM - Dynamic Data Model

"Can you test and predict the behaviour of your datamodel ?"


Ever wondered how the data model looks like with the current selections? How selections in one table have an influence on another table in your datamodel. The DynamicDataModel Module can be used to test your datamodel. Using the Distinct record ID and table statistics you can check if your datamodel behaves as intended and if the script actually created the tables as you had envisioned.

Screenshots:

Dynamic Datamodel overview

Dynamic Data Model.PNG

Auto generated multibox with multiple table statistics

Dynamic Multibox with table statistics.PNG

    Note: Trade ID is the user defined distinct record id for the table trades and has 9.964 records in the current selection

    which is 64,86% of all records in the Trades table.



Benefits:

  • Easy setup
  • Compare # distinct record ids with # rows in a table
  • Check your datamodel and tables after a script reload
  • Get a better understanding of the behaviour of your datamodel and perform business logic tests easily
  • Multiple table statistics for the current selections and the complete record set
  • Select which tables and fields should be part of the dynamic datamodel

Cons:

  • A script reload is required
  • Performance slow down for large tables (10M+)

Setup:

  • Call the DynamicDataModel subroutine.

The Dynamic Data Model Module is part of the QvM - Qlikview Modules template.

Thanks for your feedback and comments.

Have fun Qlik'n, Koen

QlikViewModules.com

Comments
arbernardez
Not applicable

quite useful

Thank you,

Regards,

Alberto Rodríguez

ahaahaaha
Not applicable

Thanks for the useful information.

Version history
Revision #:
1 of 1
Last update:
‎08-15-2016 09:09 AM
Updated by: