Lineage / Dependency Analyzer for QlikView

    A free QV App that allows you to visualize your solution as a system of related elements.


    The application scans your QV environment and automatically discovers dependencies between QVW Apps, QVD Tables, Flat files etc.

    Then it shows you what the properties of the system are: it's goals (i.e. final user analytical apps), inputs and outputs of the elements, the complexity of direct and indirect relations. All in form of a single image - graph. And in lists of course.


    Search and navigate the dependencies in an associative manner


    Just filter any Entity of interest and instantly find out which other Entities depend on this one, even if they lay far behind in a data flow. So you know where a collision would rise if you made any harmful changes (say removing a field) to this particular Element.

    Analyze the lineage of your data

    When facing a question like "what exact data sources are you using for this specific QVW App?", you'll be ready to answer it in seconds. Just make a search in Entities listbox and filter out the one, then filter Ancestor relations.
    Now you have all the necessary information - a list of all sources and transformations involved in data flows as well as their abstract scheme on the graph.

    Get a visibility into data structures

    Simply said, data in a QlikView solution is organised into Data Models (QVW) plus Data Files (QVD/Flat files) and Tables plus Fields inside them.
    The application helps you find out similarities and differences and relations between those mentioned. For example: which fields are most commonly used and which - least? Which App has the widest Fact table? If you are to make changes to a field - what Apps need to be considered? And so on.

    Known limitations and workarounds

    1. If you facing the absence of lineage metadata in particular QVWs and workaround suggested on FAQ sheet doesn't suit you please have a look at Rob's alternative approach:

    2. If you need to add more than 5 folders for scanning, place 5th 6th and consequent folders all together into Folder 5 inputbox with the following separator:




    (I know it's awkward and counter-intuitive but it works)

    The Script code

    The script is available at GitHub on the following repository: GitHub - vasiliy-petrenko/QlikView-Lineage-Dependency-Analyzer. Please feel free to learn and contribute!

    Change Log

    2018-08-13 an issue with qvw's lineage metadata misbehaviour was fixed. Only environments with QlikView 12.20 SR4+ were affected.

    2018-07-30 BNF tag was added to the script for the app being compatible with QV 12.20 (November 2017 and newer).

    2017-07-13 an issue with Date Masks misbehaviour was fixed. Only environments with QlikView 12.10 SR3 (and possibly following releases) were affected.

    2016-11-18 the script is now open and available at GitHub (see the link above).

    2016-09-02 a simple workaround is found for situations when there is a need to add more than 5 folders for scanning (thank you tony.hollywood-qi)

    2016-07-29 minor fixes in interface (thank you pcammaert)

    2016-07-28 minor fixes based on user feedback (thank you thabang_petje)