Qlik Sense App: Generic Data Profiler

[stevedark]

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/

[#2]

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

[stevedark]

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]

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

[stevedark]

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]

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!

[kaushiknsolanki]

Such a wonderful usage of the meta information.

Keep educating us Steve.

Regards,

Kaushik Solanki

[stevedark]

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.

[stevedark]

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

[ajunaidm]

Excellent tool ... But I am trying to make it more flexible and I am unable to do understand few things.  like at one time it show details of one column only. How can I make to work for multiple columns of a table or tables. 

This may help in creating a comprehensive profiling report.

[stevedark]

HI @ajunaidm,

You could achieve multiple columns with a bit of set analysis when deriving the dimension names. So, the first dimension is using minstring($Field).

The second dimension could be achieved by a minstring that avoids the first. So if the first dimension was put in a variable vDim1 you could get to the second with this:

minstring({<$Field-={'$(vDim1)'}>}$Field)

That can then be taken on and on for subsequent dimensions:

minstring({<$Field-={'$(vDim1)','$(vDim2)'}>}$Field)

I don't think it would be possible to do it for all fields, and this could get very very slow indeed anyway. Doing it for up to say the first six selected fields would give a fair bit of scope.

Hope that helps point you in the right direction for what you want to achieve.

Steve