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: 
qlikviewwizard
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
jagan
Luminary Alumni
Luminary Alumni

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
Not applicable

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

qlikviewwizard
Master II
Master II
Author

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

I don't know how to do this activity.

umerikhlas
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

crusader_
Partner - Specialist
Partner - Specialist

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

nagarjuna_kotha
Partner - Specialist II
Partner - Specialist II

Hi,

Can you share your sample Data ?

Regards,

Nagarjuna

jagan
Luminary Alumni
Luminary Alumni

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.

jagan
Luminary Alumni
Luminary Alumni

Hi,

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

Regards,

Jagan.

maleksafa
Specialist
Specialist

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

qlikviewwizard
Master II
Master II
Author

Hi ,

I am getting this error when I run.

Capture.PNG