Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello!
are there a way to know all fields used by the application, this in order to clean up fields unnecessarily loaded.
Thank you!
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
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.
Hi Martina,
Thanks for your solution. Thank you for updating me with this concept. This also works fine.
Thoppil
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
OK, what about Settings and Expression Overview, you can export them an have a look maybe in Excel.
Thanks Martina.
I found the had issue and your solution helped a lot ![]()