Discussion board where members can get started with Qlik Sense.
Hi, I have done creating data model but i got doubt ... is it correct or not, meanwhile i am checking each and area, finally i got this doubt
what exactly 1) has duplicates
2) total distinct values
3) present distinct values
4) non null values
6) subset ratio
Please anybody clarify me
Thanks in advance
From the reference manual
Information density is the number of records that have values (i.e. not NULL) in this field as compared to the total
number of records in the table.
Subset ratio is the number of distinct values of this field found in this table as compared to the total
number of distinct values of this field (that is other tables as well).
Tags that are added in the script or in Document Properties: Tables page, including system tags, are
displayed in the tool tip.
Thank you for Quick reply....
But i want know for Best data model, has duplicate should be true or false,
that subset ratio and density, how much need for best data model.
Thanks a lot
these numbers are just to validate / verify dataset information
forexample, if you didn't expect a table to have duplicates but the information shows has duplicates , so then you can look into it.