Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
chitemerere
Specialist
Specialist

Information Density and Subset ratio

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

10 Replies
iktrayanov
Creator III
Creator III

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
MVP & Luminary
MVP & Luminary

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
Creator III
Creator III

Gabriel
Partner
Partner

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.

chitemerere
Specialist
Specialist
Author

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

Regards

Chris

chitemerere
Specialist
Specialist
Author

Hi Rob,

Many thanks, i will check on it and revert.

Regards

Chris

chitemerere
Specialist
Specialist
Author

Ivan

Many thanks for your response.

Regards

Chris

chitemerere
Specialist
Specialist
Author

Ivan

Thanks for the link, most appreciated.

Regards

Chris

sudhakarm
Contributor III
Contributor III