topic Multiple rows for each file in QVWComplexity in QlikView

Multiple rows for each file in QVWComplexity

Mon, 26 Jan 2026 18:19:17 GMT

In the QVWComplexity table I get multiple rows for each file. One row pr daily load, and no date field in the table, or other uniqe identifyer. This results in strange results in the complexity Breakdown where sum is used to calculate for example size.

How do i get only one row per file (most recent)?

Re: Multiple rows for each file in QVWComplexity

Tyler_Waterfall — Wed, 26 Nov 2014 11:50:08 GMT

Sindre Gundersen - are you using Multi-Cluster?

There is a known issue with the Complexity score for multi-cluster, as you have described -- showing higher values than correct because in Multi-Cluster, the Complexity logic occurs after the daily scan of qvw metadata is appended to the 'historical' qvw metadata.

There is not a date field to filter by for the Complexity per-se.

Try selecting the latest Scan date (on the Scan Details page). Does this fix it?

Re: Multiple rows for each file in QVWComplexity

Wed, 26 Nov 2014 12:00:05 GMT

Here is a screenshot filterd on a spesific filename and cluster. There are 105 rows of that application in QVWComplexity. The Filesize is the sum of the 105 rows and not the last row.

Re: Multiple rows for each file in QVWComplexity

Wed, 26 Nov 2014 12:05:50 GMT

Yes, we are using multicluster. It sounds right what you say. The complexity logic reads the historical instead of daily qvw.

Selecting the latest date in scan detail does nothing to the result, because there is not date in the complexity table.

The only link field is the filename.

Re: Re: Multiple rows for each file in QVWComplexity

Tyler_Waterfall — Wed, 26 Nov 2014 19:15:14 GMT

Sindre Gundersen - Can you try adding the attached chart in your Governance Dashboard?

I updated the expressions to just reference the latest data (using the 'raw' data instead of the script-created Complexity fields).

Please let me know what you find. You are not the first to report this issue, and if this is helpful, I might share it more generally.

Thanks!

update: "Reload End" version the the QV object - I'm not sure if the variable todaysDateNum (referenced in the expressions) exists in the published Governance Dashboard. The Reload End version references one that indeed exists.

Re: Multiple rows for each file in QVWComplexity

Thu, 27 Nov 2014 08:28:46 GMT

These qvo files contains only your testdata and not the objects. Can you write down some of the expressions?

Re: Re: Multiple rows for each file in QVWComplexity

Tyler_Waterfall — Mon, 01 Dec 2014 12:18:24 GMT

Sorry everyone.

Here is a qvw with the object in it. Just copy the table and paste it into your Governance app.

Tyler

Re: Multiple rows for each file in QVWComplexity

Mon, 01 Dec 2014 13:30:29 GMT

Thank you! It work fine, except that the todaysDateNum variable did not exists, as you have written earlier. But by setting it like LoadDateNum it worked. Is that how your formula was set?

The top one is the original with sum of all, and the lowest one is for one load only.

Re: Re: Multiple rows for each file in QVWComplexity

Tyler_Waterfall — Mon, 01 Dec 2014 16:58:15 GMT

Sorry - wrong chart.

I re-attached the qvw above - use the chart with the green caption. It references a different variable which should exist in your app.

Re: Re: Multiple rows for each file in QVWComplexity

Wed, 03 Dec 2014 12:04:38 GMT

Sorry, it returns 0 records. ReloadEnd does not exist as field or variable.

If you add the variable definision, I can add it.

Re: Re: Multiple rows for each file in QVWComplexity

Tyler_Waterfall — Wed, 03 Dec 2014 22:17:13 GMT

Now this is strange. ReloadEnd actually does exist as a variable (you can check with CTRL+V or by clicking on the "Variables" tab in an expression editor). However, I can replicate what you are seeing using a clean Governance Dashboard.qvw (as opposed to the dev version I was testing this in.).

I am a bit baffled by this and can't find what the issue might be. I'll have to look more another day.