topic Re: Information Density and Subset ratio in QlikView

Information Density and Subset ratio

Anonymous — Mon, 29 Dec 2014 21:45:49 GMT

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

Re: Information Density and Subset ratio

iktrayanov — Mon, 29 Dec 2014 22:35:00 GMT

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

Re: Information Density and Subset ratio

rwunderlich — Mon, 29 Dec 2014 22:35:51 GMT

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

Re: Information Density and Subset ratio

iktrayanov — Mon, 29 Dec 2014 22:42:31 GMT

You may want to check this out.

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

Re: Information Density and Subset ratio

Gabriel — Mon, 29 Dec 2014 22:57:45 GMT

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.

Re: Information Density and Subset ratio

Anonymous — Tue, 30 Dec 2014 05:53:59 GMT

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

Regards

Chris

Re: Information Density and Subset ratio

Anonymous — Tue, 30 Dec 2014 05:54:41 GMT

Hi Rob,

Many thanks, i will check on it and revert.

Regards

Chris

Re: Information Density and Subset ratio

Anonymous — Tue, 30 Dec 2014 05:55:18 GMT

Ivan

Many thanks for your response.

Regards

Chris

Re: Information Density and Subset ratio

Anonymous — Tue, 30 Dec 2014 06:03:00 GMT

Ivan

Thanks for the link, most appreciated.

Regards

Chris

Re: Information Density and Subset ratio

Anonymous — Tue, 30 Dec 2014 07:03:47 GMT

I think this will help you

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

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

Re: Information Density and Subset ratio

Anonymous — Tue, 30 Dec 2014 08:54:59 GMT

Sudha

Many thanks for the link.

Regards

Chris