topic Re: Underlying columns and tables in QlikView

Underlying columns and tables

shephali_23 — Fri, 03 Jan 2020 13:41:19 GMT

I am trying to find out the underlying columns and tables of all the visualizations of a QlikView application. Is there any easy and direct way to find that out? The requirement is to find the underlying tables for a subset of views of the application

Re: Underlying columns and tables

lorenzoconforti — Fri, 03 Jan 2020 15:13:18 GMT

The governance dashboard should be able to provide some info

Otherwise you can always open a qvw file as a table from the loading script, select xml as file type and you will be presented with a list of tables which include all the info you are looking for and the relationship between the various objects (sheet > table > field/expressions)

Re: Underlying columns and tables

Brett_Bleess — Mon, 06 Jan 2020 14:14:35 GMT

Shephali, not exactly sure for what you are looking on this one, but I wanted to provide you the link to the Governance Dashboard material Lorenzo mentioned just in case you had trouble finding that:

https://community.qlik.com/t5/Qlik-Monitoring-Administration/QlikView-Governance-Dashboard/gpm-p/1578596

https://help.qlik.com/en-US/governance-dashboard/Content/What.htm

If you can provide some further details on what you are actually trying to solve, that may help us come up with some further ideas, I am hesitant to throw out much else without knowing more...

Regards,
Brett