Qlik Community

QlikView Documents

Documents for QlikView related information.

QvM - Key Check

cheburashka
Contributor III

QvM - Key Check

"How to check the links between your tables? Do the values of the key between the two tables match as predicted?"

When building a data model it is important that you have a good understanding of the links between the tables of your data model. To test the link between 2 tables I want to know which values of my key exist only in table A, only in table B or in both tables. The Key Check module (subroutine + set of frontend objects) can help you with answering this question.


Screenshots:

Key Check overview


Key Check Screenshot.PNG

Benefits:

  • Statistics of your keys in a blink
  • Easy setup
  • Flexible - Check multiple keys with the same frontend objects
  • Improve your understanding of your data model by analyzing your links/keys

Cons:

  • A script reload is required

Setup:

Call the KeyCheck subroutine.

The Key Check module is part of the QvM - Qlikview Modules template.

Thanks for your feedback and comments.

Have fun Qlik'n, Koen

QlikViewModules.com


Comments
beck110979
Valued Contributor III

Thanks for sharing

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