topic Re: Qvw file struture in QlikView

Qvw file struture

Wed, 03 Oct 2012 18:40:51 GMT

Hi all,

I'm trying to document which textfiles/excel files etc I'm using in each of my QVW files so I can have an overview of what my QVW files contain.

I'd like to do this without having to mannually look into the scripts, and copying the file extension.

Outside of qlikview.. I used a tree forumula : tree[Drive:] [path] to record my own folders/files used. I was curious if Qlikview had this same sort of functionality.

Any advice would be greatly appreciated.

Thank you

-Liz

Re: Qvw file struture

Wed, 03 Oct 2012 18:50:16 GMT

I guess one way to think of this is seeing if there is a way to select only the file extension after FROM in the script..

Re: Qvw file struture

rwunderlich — Thu, 04 Oct 2012 05:00:31 GMT

You might want to try the DataLineage sub in Qlikview Components http://qlikviewcomponents.org. With one line

CALL Qvc.DataLineage;

you can generate a table of sources used in your QVW. It's a new feature and I haven't got any feedback on it yet. I just tried it at a customer and got imcomplete results, but I haven't had a chance to debug it. I'd be curious to get feedback from others.

-Rob