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 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

     

    Cons:

    • A script reload is required

     

    Setup:

    Include the QvM.qvs script and the frontend objects and call the KeyCheck subroutine.

    More details in the example of QvM

     

    Download:

    You can download the QvM zip at the end of the QvM - Qlikview Modules post.

     

    Thanks for your feedback and comments.

    Have fun Qlik'n, Koen