topic Re: How to Drop unused fields from the Data Model in QlikView

How to Drop unused fields from the Data Model

Anonymous — Mon, 19 Jun 2017 23:09:10 GMT

Hi,

Can anyone tell me how to drop unused fields from data model? There are many unused fields existing and it takes lot of time to drop manually. The dashboard gets really slow while use. I was trying to improve performance. Please suggest.

Thanks,

Mohith

Re: How to Drop unused fields from the Data Model

passionate — Tue, 20 Jun 2017 06:44:52 GMT

Hi Mohith,

You can use Document analyser to find unused field and then drop field.

Document Analyzer V3.0 Update Available

Regards,

Pankaj

Re: How to Drop unused fields from the Data Model

ahaahaaha — Tue, 20 Jun 2017 07:24:03 GMT

Hi Mohith,

Use Drop field ‒ QlikView‌

Regards,

Andrey

Re: How to Drop unused fields from the Data Model

prma7799 — Tue, 20 Jun 2017 07:34:24 GMT

You can comment that unused fields Or drop unwanted fields using DROP function.

ABC:

Load

from ABC.qvd

Drop Fields A,B;

Or simply comment

ABC:

Load

//a,

//b,

from ABC.qvd

Re: How to Drop unused fields from the Data Model

rwunderlich — Tue, 04 Jul 2017 21:52:22 GMT

You mentioned it takes a lot of time to "drop manually", I'll assume you mean using DROP FIELD statements. Tip: Don't use a separate DROP statement men for each field, Instead, combine the field into one DROP statement.

DROP FIELDS F1,

F2,

;

-Rob

Re: How to Drop unused fields from the Data Model

SimonDB — Fri, 19 Sep 2025 12:32:44 GMT

You can do this with an automation... details on this youtube video. Worked perfectly for me
Qlik Field Usage Automation - YouTube

GitHub - eapowertools/qlik-field-usage-automation: Inactive - A Qlik Application Automation template and programmatically generated app for Qlik Sense apps in Qlik Cloud that exposes field usage and allows for impact analysis.

Re: How to Drop unused fields from the Data Model

SunilChauhan — Fri, 19 Sep 2025 13:07:42 GMT

Step

1. Analyse you app for unused fields.

2. comment unused field used one time in script;

3. Drop statement to drop the field mentioned i above post.

here first step is important to identify fields which are unused i,e not used in in Variable, expression or anytype of Calculation.