Data quality within document

[#1]

Hi all.

I'm looking for a way to loop through all the fields in a document and report on the data quality per field. Just looking to create a simple report showing how many records are populated per field and perhaps the number of distinct values per field. Does anyone know of a handy method or script code to use for this?

Regards

Mertin Strydom

[tresesco]

Perhaps System fields ‒ QlikView  and Table functions ‒ QlikView can help you here.

[prieper]

I usually use the attached sheet and copy it into the application (similar to the links above)

Peter

[#4]

Wow, thanks, that looks very handy indeed. I think the ultimate solution I'm looking for is to get a view of all the data from a flat denormalized view, so that the max number of populated records per field has the potential to have the same count and then to see how many are not populated per field. Then one could go and investigate those.. I probably need to think this through a bit more, but what you've given me so far, is indeed handy, so big thanks!