I've been tasked with cleaning up an existing Qlikview file. One of the issues I have is verifying if and how the fields being loaded are used in any of the charts so I can begin to trim down the script... there are 167 fields across 16 different tables. Fortunately, there are no synthetic keys, but there are a couple of tables that are orphaned and I'm not certain they are necessary.
Does anyone know of a way to search for the presence of a particular table field in the charts without having to open each tab/chart individually? Or is there a way to get the inventory of all the fields being displayed by chart? It would make my life a lot easier.
You can use Rob Wunderlichs Document Analyzer. It will analyze your document and generate tables with a lot of information about your document. You'll have to add a chart to show the relations between field and charts. The information is available in the generated tables, but there's not a chart that displays that.
You can use Rob Wunderlichs Document Analyzer. It will analyze your document and generate tables with a lot of information about your document. You'll have to add a chart to show the relations between field and charts. The information is available in the generated tables, but there's not a chart that displays that.
