"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.
Key Check overview
- Statistics of your key in a blink
- Easy setup
- Flexible - Check multiple keys with the same frontend objects
- Improve your understanding of your data model by analyzing one link at a time
- A script reload is required
Include the QvM.qvs script and the frontend objects and call the KeyCheck subroutine.
More details in the example of QvM
You can download the QvM zip at the end of the QvM - Qlikview Modules post.
30/12/2016: Make KeyCheck Module fields hidden.
Thanks for your feedback and comments.
Have fun Qlik'n, Koen