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