Discussion Board for collaboration related to QlikView App Development.
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!!
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
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
];
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