How to find table columns/fields which are used in the report/dashboard?

[tanmay_bhardwaj]

Hi All

I am working on performance optimization of an existing QlikView dashboard. Its design is based on 3 Tier architecture and in the existing code the developer has pulled all the columns (using select *) from the input tables.

The final dashboard is quite big and complex and my first action item is to import only those table columns from input tables which are used in the charts instead of using a select * clause which is currently implemented.

Is there any way to find table columns which are not used in any of the chart or not(in dimension/expression/variable). I don't want to open one by one chart and see if it using a particular field as it will take a lot of time for analysis.

Can some one please help me out with the best way to investigate this.

Thanks in Advance

[Vegar · Accepted solution]

I would recommend you to look into @rwunderlich excellent QlikView Document Analyzer. It will help you identify your unused fields and more. 

https://qlikviewcookbook.com/tools/#squelch-taas-accordion-shortcode-content-5 

[tanmay_bhardwaj]

@Vegar this is super useful. The tool looks very exhaustive, is there any document/user guide which explains the and features and how to understand/interpret them? 

Also, just to be sure is the information extracted by this tool always 100% accurate? 

[rwunderlich · Accepted solution]

Hi, I'm the author of the tool.  There is no user guide for the tool. It is a QlikView app so feel free to poke around and make your own charts. 

100% accuracy is not guaranteed, but experience has shown it to be reliable. I recommend you review the field recommendations and not accept them blindly. You will get the most benefit from dropping the larger fields so concentrate on those first.

I'm no longer actively maintaining it so have not tested with recent QV versions. 

-Rob

[aTw]

Does it work for Qlike Sense Enterprise also? 

[rwunderlich]

A different tool for Qlik Sense -- QSDA Pro. 

-Rob

[NadiaB]

Hi @tanmay_bhardwaj 

Not related to fields, but if you are looking to app performance the following tools could provide some extra information:

Telemetry Dashboard

https://adminplaybook.qlik-poc.com/docs/tooling/telemetry_dashboard.html

Metadata Analyzer

https://adminplaybook.qlik-poc.com/docs/tooling/app_metadata_analyzer.html

Hope it helps. 

[lu156478864]

Hi,

don´t you have also solution for Qlik Cloud?

Thank you

[rwunderlich]

QSDA Pro works with both Qlik Cloud and Qlik Sense Enterprise.

-Rob