topic Re: Information Density and Subset ratio in QlikView

Information Density and Subset ratio

saiharsha799 — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I want to know the formula for Information Density and Subset ratio and how we can get the percentage in QV.

Explain briefly.

Re: Information Density and Subset ratio

SharathPanackal — Thu, 06 Dec 2018 03:42:47 GMT

Hi Saiharsha,

Information density is the percentage of non null values within a tablein the data model.

Subset ratio is the percent of distinct values of the column inside a table when compared to the total list of distinct values of the same column in the entire data model

Hope i have answered your query

Re: Information Density and Subset ratio

SharathPanackal — Thu, 06 Dec 2018 03:59:08 GMT

Please find a discussion on the same in https://community.qlik.com/t5/New-to-QlikView/information-density-and-subset-ratio-What-is-the-use-of-this/td-p/597042.