Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Learn how to migrate to Qlik Cloud Analytics™: On-Demand Briefing!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Know the fields used

Hello!

are there a way to know all fields used by the application, this in order to clean up fields unnecessarily loaded.

Thank you!

7 Replies
Not applicable
Author

Hi Heddicimi,

After extracting all the data into QlikView, you can go to the table viewer by pressing "ctrl T". Here you will be able to see all the tables, fields used in each table, the different links between the tables and the fields which helps to create this link. You can also see all the field names used in the application here. This is one possible solution.

The other way is to do a right click and click the select tab so that all the fields used will be displayed.

Hope this helps you

Thoppil

brenner_martina
Partner - Specialist II
Partner - Specialist II

Hi,

and the next possible way is to create a New Sheet Object called: System Table and/or Select fields by click on Show System Filds and choose here $Table, $Fileds and so on. Here you can also select a Table and you get all its fields. If you create a table box with specified fields, you get all data listed, entered in this table.

Not applicable
Author

Hi Martina,

Thanks for your solution. Thank you for updating me with this concept. This also works fine.

Thoppil

Not applicable
Author

Ok thanks... but it's not reaaly what I want.

I don't whant to know all fields. no. I want to know which fields are using in my application for a dimension or expression (or something else) in my graphs, straight table, etc.

Then I will be able to say "ok, we are loading this table with X fields... But only Y are using as a dimension or expresion. The difference are not used. So i can NOT load this fields"

do you see ?

For me, your solution will only show me fields

brenner_martina
Partner - Specialist II
Partner - Specialist II

OK, what about Settings and Expression Overview, you can export them an have a look maybe in Excel.

Not applicable
Author

Rob has a Document Analyzer which does that.

http://robwunderlich.com/Download.html

/Michael

Not applicable
Author

Thanks Martina.

I found the had issue and your solution helped a lot