topic AW:Re: Know the fields used in QlikView

Know the fields used

Thu, 08 Jul 2010 11:06:12 GMT

Hello!

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

Thank you!

Know the fields used

Thu, 08 Jul 2010 11:41:37 GMT

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

AW:Re: Know the fields used

brenner_martina — Thu, 08 Jul 2010 11:49:09 GMT

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.

AW:Re: Know the fields used

Thu, 08 Jul 2010 11:54:14 GMT

Hi Martina,

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

Thoppil

Know the fields used

Thu, 08 Jul 2010 11:55:23 GMT

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

AW:Re: Know the fields used

brenner_martina — Thu, 08 Jul 2010 12:46:55 GMT

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

SV:Re: Know the fields used

Thu, 08 Jul 2010 13:05:09 GMT

Rob has a Document Analyzer which does that.

http://robwunderlich.com/Download.html

/Michael

Know the fields used

Wed, 19 Oct 2011 14:10:55 GMT

Thanks Martina.

I found the had issue and your solution helped a lot