Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
tanmay_bhardwaj
Contributor III
Contributor III

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

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

Labels (2)
2 Solutions

Accepted Solutions
Vegar
MVP
MVP

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 

View solution in original post

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

View solution in original post

6 Replies
Vegar
MVP
MVP

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
Contributor III
Contributor III
Author

@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
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Partner - Contributor II
Partner - Contributor II

Does it work for Qlike Sense Enterprise also? 

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

A different tool for Qlik Sense -- QSDA Pro. 

-Rob

NadiaB
Support
Support

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. 

Don't forget to mark as "Solution Accepted" the comment that resolves the question/issue. #ngm