Information Density and Subset ratio

[Anonymous]

I have two tables, [Main Data] and [Drug List] which are linked via a field [Drug Code].  I have the following information for the two tables:

[Main Data] - [Drug Code] has an information density of 99.45% and a subset ratio of 61%

[Drug File] - [Drug Code] has an information density of 100% and a subset ratio of 61%

i seem to be losing a lot of information within this link as the [Drug File] gives a lot of null values.  What could be happening?

Regards

Chris

[iktrayanov]

You probably have Drug codes in the main data that are not in your reference table(Drug file.) Probably xxxxxxxx vs xx-xxx-xxx or something like this.

Hope that helps.

Ivan

[rwunderlich]

My guess is that the tables are using different value encodings for [Drug Code]. Like in one table the code has a prefix and not in the other.

-Rob

[iktrayanov]

You may want to check this out.

http://www.emdeon.com/resourcepdfs/NDCconversionto11digits.pdf

[Gabriel]

Hi,

To understand what the problem is, load [Drug Code] from [Main Data] table give it a name and QUALIFY this new table and do same for [Drug Code] from Drug file table give it a name and QUALIFY this table.

Then in UI put list box for each [Drug Code] from this new tables you've just created and SEND TO EXCEL. Analyzing the excel file should tell the story.

My guess is there are Drug Codes not matching hence the NULL value.

[Anonymous]

Many thanks Gabriel, let me work on it and will advise you accordingly.

Regards

Chris

[Anonymous]

Hi Rob,

Many thanks, i will check on it and revert.

Regards

Chris

[Anonymous]

Ivan

Many thanks for your response.

Regards

Chris

[Anonymous]

Ivan

Thanks for the link, most appreciated.

Regards

Chris

[Anonymous]

Hi

I think this will help you

information density and subset ratio? What is the use of this?

http://community.qlik.com/thread/107703