topic Create table of Qlik data model Table Names and Field Names in QlikView

Create table of Qlik data model Table Names and Field Names

jeckstein — Mon, 06 Mar 2017 03:19:46 GMT

I want to create a summary table that shows me stats from a data model I create. I want a piece of code to place at the end of my script editor that creates this summary table. This table must be Qualified so it does not interfere with the existing data model

In the script editor I want to create a table that follows this logic.

column 1= table name
column 2=field names
column 3= count (# of rows)
column 4= count (distinct( # of rows)

Theses 4 columns are defined as follows

field name= the field name for each specific field in my data model
table name= the table name which the field is from
column 3= count the number of rows for this field in this table
column 4= count the number of distinct values for this field in this table

Please let me know if you have any ideas

Re: Create table of Qlik data model Table Names and Field Names

sumitjadhav — Mon, 06 Mar 2017 05:33:28 GMT

Hi James,

Follow the below steps :

-->>First goto your Sheet Properties

-->>Goto Fields Tab and then,

Tick the checkbox to show System Fields as Below,

-->Now ,Add the Required System Fields and Create a table box as below,

Hope This was Helpful.

Thanks & Regards,

Sumit Jadhav.

Re: Create table of Qlik data model Table Names and Field Names

avinashelite — Mon, 06 Mar 2017 05:40:19 GMT

This tables are generated by default , full the instruction as Sumit mentioned

Re: Create table of Qlik data model Table Names and Field Names

jonathandienst — Mon, 06 Mar 2017 05:52:46 GMT

You can get a starting point for the front end by selecting New Sheet Object from the Object menu in QV desktop. Select System table from the bottom of the list. This is a pivot table of the tables and fields using the $Tables and $Field.

Re: Create table of Qlik data model Table Names and Field Names

jeckstein — Mon, 06 Mar 2017 15:12:13 GMT

Is there any way to get a distinct field count?