Complexity Analyzer Index

Owned by Sales (Unlicensed)
Sept 20, 2022
1 min read

Each Qlik Application has a Complexity Index value in the file. The complexity value of a file is a sum of several different measures of complexity of a file’s content, including number of tables, number of fields, number of sheets, objects, expressions, calculated dimensions, etc. WIP users have the option of changing the weighting factor for any of these individual complexity measures as well as setting their thresholds.

 

Applications that exceed the threshold of one or more attributes are probably those whose performance could be improved by reducing their complexity. Their improvement is also likely to benefit the QlikView Server performance by reducing system resource requirements.

 

The measures in the Complexity Indexes are:

  • Base is the level for factoring into the complexity index. If a file contains tables, sheets, or other objects whose counts are below the base settings, then those elements are not calculated in the complexity index. Any number that exceeds the base is used in the complexity index. For example, if the Tables Base is 5, and a file has 6 tables, then 1 would be used to calculate the complexity index.

  • The Max value is used as a divisor in the complexity index calculation, so the higher the Max value, the lower the impact of counts that exceed the Base.

  • The Weight is a multiplier in the complexity index calculation, so the higher the Weight, the greater impact of counts that exceed the Base.