Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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

Highlighted
Not applicable

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

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%

Highlighted
Specialist
Specialist

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

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

Highlighted
Specialist
Specialist

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

Very nicely explained. Thanks.

Highlighted
Partner
Partner

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

what a useful information!! thank you!!

Highlighted
Champion
Champion

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

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

Highlighted
Creator
Creator

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