Qlik Community

Qlik Sense Enterprise Documents

Documents for Qlik Sense related information.

Qlik Sense App: Generic Data Profiler

MVP
MVP

Qlik Sense App: Generic Data Profiler

This app has a number of objects that work together to allow you to see the frequency of values on any field in your own apps.  The field is selected from a Filter Pane and then a Bar Chart object shows the frequency of values within the selected field.  There is also a Filter Pane on the selected field, allowing searching on that field.

The objects can be copied and pasted into any Sense document, allowing this functionality on any data set.

A full tutorial on how to build the components in this app, using only standard Sense features, is given in a blog post which you can find here:

https://www.quickintelligence.co.uk/qlik-sense-data-profiler/

This app is a Sense port of our popular QlikView app, which can be found here:

QlikView App - Generic Data Profiler


I hope that you find the application useful.  You will find other applications that I have uploaded under my profile on QlikCommunity or on our Downloads page..

Steve

http://www.quickintelligence.co.uk/qlikview-blog/

Attachments
Comments
Not applicable

Thank you very much

I have been using this your development in QlikView for several years. Very easy to reconcile and debug the data model

MVP
MVP

Thank you Alexander - pleased to hear you have been finding the QV version useful, hope the Sense one proves as useful in future.

sumit_ranjan_pa
Contributor

This is really Nice. I need to do an POC on this

MVP
MVP

Thank you, I'm glad you like it.  The objects can be copied from one Sense app to another, so you can use it wherever you like, and the techniques used (described in the blog post) can be used for other applications also.

sumit_ranjan_pa
Contributor

I had plan to use Python for data processing and just use QS for the VIZ. Now if this works as my plan, then i have got the entire package at hand. Much appreciated!

Such a wonderful usage of the meta information.

Keep educating us Steve.

Regards,

Kaushik Solanki

MVP
MVP

Hi Sumit,  if it is not quite what you need then it's all open for you to modify.  When I am doing data profiling I will usually also bring the data into QlikView and export structure files - these give you a lot of useful information for deciding what to do with fields.

There is quite a lot more profiling functionality built in to the Data Manager.  The problem with this functionality is that it is only available to the developer.  Often that is all you need though.

MVP
MVP

Thanks Kaushik - glad you like it.  Hoping to do more similar blog posts and apps soon.

Version history
Revision #:
1 of 1
Last update:
‎10-11-2017 05:36 PM
Updated by: