How to Drop unused fields from the Data Model

[Anonymous]

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

[passionate]

Hi Mohith,

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

Document Analyzer V3.0 Update Available

Regards,

Pankaj

[ahaahaaha]

Hi Mohith,

Use  Drop field ‒ QlikView‌

Regards,

Andrey

[prma7799]

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

ABC:

Load

a,

b,

c,

d,

e

from ABC.qvd

Drop Fields A,B;

Or simply comment

ABC:

Load

//a,

//b,

c,

d,

e

from ABC.qvd

[rwunderlich]

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,

F3

;

-Rob

[SimonDB]

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...

[SunilChauhan]

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.