QlikView App - Generic Data Profiler

[stevedark]

Often when building QlikView applications, or picking up applications which have been built by someone else I want to have a quick and easy way of viewing the data that is in that application.  To enable me to do this I have put together a page of objects that lists all tables and fields in the data model and then gives outline information about any selected field.  These objects can be copied and pasted into any QlikView application to view the data model of that document.

I have documented how this document works and the reasons why you might use it in a blog post here:

https://www.quickintelligence.co.uk/qlikview-data-profiler/

Please see the blog post for further details on using this document.

There is now a Qlik Sense version of this app, which you can find on Qlik Community here:

Qlik Sense App: Generic Data Profiler

I hope that you find it useful.  You will find other applications that I have uploaded under my profile on QlikCommunity, or on our Downloads Page.

Steve

https://www.quickintelligence.co.uk/blog/

‎

PLEASE NOTE: The 'With Mask' version of the file includes an experimental tab that may or may not work well on large data sets.  Please see comment below for details.  If you are not sure which to download go for DataProfiler.qvw.  Thanks!

[mayankraoka]

Too good  Steve...Useful

[stevedark]

Thanks Roy and Mayank

[ecolomer]

Good Job

Thank's for sharing

Saludos,

Enrique Colomer

[hectorgarcia]

Thanks steve for your contrinution.

Have you ever think having this profiling at script level ? creating a table for each field with their stats showed in the table Min Value, max value etc??? it will be great to create data quality insights in qvd's and then use them for Data quality monitoring 

[stevedark]

Hi @hectorgarcia ,

Thanks for your comments. To get all of the measures that are in the table loaded into a table would require a GROUP BY done in the load script for each table. It could add a chunk of time to the load time. Interesting thought though.

Most of the stats though can be retrieved from the QVD header though, and I have a separate app for profiling QVDs. There is a blog post and download for that here:

https://www.quickintelligence.co.uk/qlik-qvd-xml-header-viewer/

Also, you may be interested in the Instant Sense App I have created, which loads any data set and a spreadsheet of metadata and presents the data in a twelve sheet app. I'm presenting this at the Qlik Virtual Meetup Scotland on Friday, and it will be available for download by attendees:

https://www.linkedin.com/posts/stevedark_qlikmeetupscotland-qlikluminary-data-activity-6663354985822...

Cheers,

Steve