topic Quickest Way to View All Data in QVD in QlikView

Quickest Way to View All Data in QVD

Thu, 20 Oct 2011 13:29:29 GMT

I'm totally new to QV. I have to manage several dashboards. One of them pulls data from several QVD files, which are loaded each night from a SQL Server data warehouse. I'm trying to trace some data, and once it (apparently) gets SELECTed and supposedly loaded into one of the QVDs, it does not seem to come out the other end. That is, it's not accounted for in my dashboard.

I would like to whip up a QlikView dashboard that simply shows me the row-level contents of the QVD "database" in question. In effect, almost like going into SSMS and typing "SELECT * FROM tblVisits". I would want to narrow down by maybe two filters, but bring back all columns of data, down to the row level.

Should this be a simple, straightforward project? How do I start?

Thanks in advance.

Quickest Way to View All Data in QVD

jonathandienst — Thu, 20 Oct 2011 15:03:26 GMT

Two suggestions - first, you can drag a QVD and drop it on the QV icon (or on the start page ifs open). This will create a new qvw file, and open the file load wizard with the preview window open, so you can see the fields and content. It you click cancel, no file will be created.

But this doesn't tell you much about metadata like cardinality. I have downloaded a QVD viewer in the past that did that. Search here for "QVD viewer" and you might be able to find it. This is a model that loads a sample (or all) of the date, and computes meta data for the QVD.

Hope this helps

Jonathan

Quickest Way to View All Data in QVD

Thu, 20 Oct 2011 15:07:50 GMT

Thank you! I'll give it a whirl.

Quickest Way to View All Data in QVD

Tue, 05 Jun 2012 16:00:23 GMT

I wrote simple QVD viewer which shows row-level data of a QVD file and some metadata. You can download it here: bi-review.blogspot.com/p/fast-qvd-viewer.html

Re: Quickest Way to View All Data in QVD

Tue, 05 Jun 2012 16:04:17 GMT

Thanks. I'll check it out --