Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
information density and subset ratio? What is the use of this?
thanks in advance
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
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
Information density:
country | code |
---|---|
Afghanistan | AF |
Albania | |
Algeria | DZ |
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%
Thanks Manish & Amit das for your valuable inputs !!!
Very nicely explained. Thanks.
what a useful information!! thank you!!
I can see 100% Information density on both code and Country, can you please let me know how to see 67%