Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

thanks in advance

17 Replies
Not applicable
Author

Mate, look for parent-child relationships between tables and go from there. For eg. Ticket Header Table - Ticket Details Table - there has to be a link between the 2 ie. Ticket No. in the details table is enough to bring all the details by the associative nature of qlikview - who needs the keys, throw in a counter field ie. set =1 , bobs your uncle.

I'm a SQL Server and Access DB expert - now building up in SAP BI so far only a practiioner - will be expert soon

Not applicable
Author

Nice

and information density which shows null values  is present for every field but subset ratio is for only field on which the connection is formed

Not applicable
Author

Information density:

country
code
AfghanistanAF
Albania
AlgeriaDZ

After loading the above records, go to the table viewer section (CTRL+t)

mouse over on "country" field, you will see Information density is 100%

Now mouse over on "code" field, you will see Information density is less than 100% i.e 67%

It means that, code field contains a null value in 2nd row that's why it is showing Information density is 67%

Anonymous
Not applicable
Author

Thanks Manish & Amit das  for your valuable inputs !!!

montubhardwaj
Specialist
Specialist

Very nicely explained. Thanks.

luiskeyrus
Partner - Contributor III
Partner - Contributor III

what a useful information!! thank you!!

SunilChauhan
Champion
Champion

I can see 100% Information density on both code and Country, can you please let me know how to see 67%

Sunil Chauhan
ysj
Creator
Creator