Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Master II
Master II

Finding and dropping unnecessary fields in QVW applications

Hi QV folks,

As part of improving performance of MyQVWApp.qvw , I needed to finding unnecessary fields/unused fields in reports and dashboards.\

I downloaded DocumentAnalyzer_V2.3.qvw and selected MyQVWApp.qvw and executed.

But is not working.

Please help me.

Thanks in advance.

1 Solution

Accepted Solutions
Highlighted
MVP & Luminary
MVP & Luminary

Hi,

I am using DocumentAnalyser_v1.15 file and it is working fine with no issues.  Get the latest version and try.

Regards,

Jagan.

View solution in original post

11 Replies
Highlighted
Not applicable

what is the condition / criteria to know which field is unnecessary?

Highlighted
Master II
Master II

I want to keep used fields of reports/dashboards. Remaining should be deleted.

I don't know how to do this activity.

Highlighted
Contributor III
Contributor III

Try the updated version i.e. version 2.4 and follow the given steps.

You can download it from the link below:

http://qlikviewcookbook.com/recipes/download-info/document-analyzer/

a helpful document for the QlikView Developers by Rob

Thanks & Regards,

UI

Highlighted
Partner
Partner

Hi,

Try to use Document Analyzer created by Rob Wunderlich

It's nice tool (QV document in fact) to find unused fields and has other useful features.

Tools | Qlikview Cookbook

Regards,

Andrei Kaliahin

Highlighted
Partner
Partner

Hi,

Can you share your sample Data ?

Regards,

Nagarjuna

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

You can drop the unused non key fields by using DROP FIELDS statement.

DROP FIELDS Field1, Field2, ..... ;

Or you can get this statement from the DROP FIELDS Statements list box.

Note: Don't drop the key fields

Hope this helps you.

Regards,

Jagan.

Highlighted
MVP & Luminary
MVP & Luminary

Hi,

Put this statement at the end of your script if there is dependency, if no comment this field while loading.

Regards,

Jagan.

Highlighted
Specialist
Specialist

the document analyzer is exactly what you need. what was the problem when you used it?

Highlighted
Master II
Master II

Hi ,

I am getting this error when I run.

Capture.PNG