Qlik Community

QlikView Documents

Documents for QlikView related information.

QlikView App - Generic Data Profiler

MVP & Luminary
MVP & Luminary

QlikView App - Generic Data Profiler

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:

http://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

http://www.quickintelligence.co.uk/qlikview-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!

Attachments
Comments
rustyfishbones
Honored Contributor II

Thanks Steve, another gem from you!

djlagaffe
Contributor

Thanks!

mikkeltaylor
Contributor II

Cheers Steve, I've already found it very useful as I didn't know you could read in tables from wikipedia/web pages so easily!

MVP & Luminary
MVP & Luminary

Hi Michael, I use web data quite often when seeding demonstration apps, it's my next choice after INLINE and AUTOGENERATE.  I forget that it might not be that obvious to others that you can do this.

I created a video on loading from a web page a few years back:

http://www.quickintelligence.co.uk/loading-data-from-a-web-page/

Steve

carbal1952
Contributor II

Thanks Steve: This offers a world of possibilities.

mikkeltaylor
Contributor II

Thanks Steve, the video proved very useful as I was getting mixed results just changing the url, as I didn't even think about using the wizard.

MVP
MVP

Nice post. Something new which I never ever thought.

MVP & Luminary
MVP & Luminary

Thanks Manish and Massimo for your comments.

0 Likes
Not applicable

Thanks Steve..Its very useful and it will reduce our testing time for sure..

Marcio_Campestrini
Valued Contributor

Thanks for the app!

Version history
Revision #:
1 of 1
Last update:
‎2013-10-16 01:07 PM
Updated by: