topic Re: information density in qlik view in QlikView

information density in qlik view

Fri, 20 Nov 2020 18:02:30 GMT

hi all,

what does the information density and subset ratio means in internal table view in qlik view?

Thamks

Re: information density in qlik view

maternmi — Thu, 05 Feb 2015 08:39:25 GMT

Hi Vikram,

you should read the following article

http://community.qlik.com/blogs/qlikviewdesignblog/2013/06/18/the-table-Viewer

Michael

Re: information density in qlik view

jpenuliar — Thu, 05 Feb 2015 08:40:47 GMT

From Qlikview 11 for developers book by Miguel Garcia and Barry Harmsen; PACKT Publishing.

Highly recommended purchase

• Information density of the field, which indicates the percentage of rows that

contain a non-null value.

• Subset ratio, which shows the percentage of all distinct values for a field in

the table compared to all the distinct values for that field in the entire data

model. It is only relevant for key fields since they are present in multiple

tables and do not all share the same value. Subset ratios can be used to easily

spot problems in key field associations. For example, when the combined

total of subset ratios for multiple tables is 100 percent, this may indicate that

there are no matching keys between these tables.

Re: information density in qlik view

rubenmarin — Thu, 05 Feb 2015 08:43:33 GMT

Hi Vikram,

information density: % of non-null values

subset ratio: % of distinct values of the field in that table vs distinct values of that field in all tables (only appears in linked fields.

Re: information density in qlik view

its_anandrjs — Thu, 05 Feb 2015 08:47:04 GMT

Hi,

Information Density means if any field has connected associated with any table field haw many keys are available in both the tables it is the density.

Check this simple two tables

Fact:

LOAD * Inline [

ID,Amount

1,100

2,200

3,300

4,400

5,500

];

Dim:

LOAD * Inline [

ID,Desc

3,Reg1

4,Reg2

];

In this both fact table has all key rows but the Dim table does not have all keys then in compare to fact Dim table has less density for more click Ctrl + T to view table view.

But in the fact there is 100% density.

Regards

Anand