Qlik Community

Ask a Question

QlikView Documents

QlikView documentation and resources.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE

QlikView App - Generic Data Profiler

stevedark
Luminary Alumni
Luminary Alumni

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
Master II
Master II

Thanks Steve, another gem from you!

djlagaffe
Creator
Creator

Thanks!

mikkeltaylor
Creator II
Creator 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!

stevedark
Luminary Alumni
Luminary Alumni

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
Creator II
Creator II

Thanks Steve: This offers a world of possibilities.

mikkeltaylor
Creator II
Creator 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.

MK_QSL
MVP
MVP

Nice post. Something new which I never ever thought.

stevedark
Luminary Alumni
Luminary Alumni

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
Specialist
Specialist

Thanks for the app!

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