I need metadata of loaded tables, like number of rows, no of columns, type of data either numeric or character, number of nulls in table. Please help me if we can write some function or some way to get this information out of table.
Open the Document Properties window and look at the information on the Tables tab. For individual fields you can add Statistics Box objects and add the information items you want to see for that field.
Hi navdeep kumar.
This metadata, except data types and null counter, is extracted in Qlik Deployment Framework.
The app is called IndexMonitor.qvw.
You are free to amend it to pick up what else you require, like null counter and data types.
You could export such a structure-table - here: Re: Chart with count of $Field values you could find a very sophisticated solution from rbecher. Also possible is it to create those informations with table- and field-functions within the script: Re: Save All Field Names In New Table - but both solutions are not fast by large applications and a reducing to the realy needed topics is necessary.
Further you could read the xml-metadata from a qvw and/or the layout-export to get a lot of informations from them. For this you should look to various tools which already exists: