topic Viewing all input sources and output files in QlikView

Viewing all input sources and output files

Wed, 07 Dec 2011 15:48:52 GMT

Hi there,

Is there a way to get a graphical view of all input and output files of a qlikview document, similar to how the Table Viewer gives a graphical representation of all the tables being used?

If not a graphical view, perhaps even a list view displaying where my qlikview document reads in data from, and what qvd files the document is creating?

Thanks!!

Viewing all input sources and output files

Wed, 07 Dec 2011 17:07:04 GMT

Alikim,

This information to my knowledge isnt recorded in qlikview metadata. But you can generate log file while reload and this can be loaded as a tab delimited file and analyse what you need. Of course you need to carefully filter what you need which may be a labouries task but achievable.

Regards,

Kiran

Re: Viewing all input sources and output files

johnw — Wed, 07 Dec 2011 21:01:15 GMT

This isn't exactly what you're asking for but may be helpful. I include script like this in all of my user applications, then show a chart with this data on it. I don't expect any users ever go to the tab and look at it, but it's quite convenient for me as a developer.

[Data Source Load Times]:
LOAD
"Data Source"
,timestamp(rangemax(evaluate('qvdcreatetime(' & chr(39) & '..\..\server\MasterData\QVD\'
                   & replace("Data Source",' ','_') & '.qvd' & chr(39) & ')')
                   ,evaluate('qvdcreatetime(' & chr(39) & '..\..\server\MasterData\QVD\'
                   & replace("Data Source",' ','') & '.qvd' & chr(39) & ')'))) as "Last Loaded"
INLINE [
Data Source
Address
Catalog
Coil
Customer
Manufacturing Instructions
Order Item
Order Item Expected Proceeds
];

Viewing all input sources and output files

rwunderlich — Thu, 08 Dec 2011 06:38:52 GMT

Head on over to the Meta Model group http://community.qlik.com/groups/meta-model-qv-power-tool and you'll find everything you need even a graphical view of input and output.

-Rob

http://robwunderlich.com