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: 
vangurideepu
Creator
Creator

Hi Qlik Experts... I have Data Model Query in 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

                    5) density

                    6) subset ratio

Untitled.jpg

Please anybody clarify me

Thanks in advance

Pradeep

6 Replies
vinieme12
Champion III
Champion III

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).

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

Tags that are added in the script or in Document Properties: Tables page, including system tags, are

displayed in the tool tip.

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vangurideepu
Creator
Creator
Author

Hi Vineeth,

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

Pradeep

vinieme12
Champion III
Champion III

there is ABSOLUTELY NO SUCH RULE

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vinieme12
Champion III
Champion III

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.

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
vangurideepu
Creator
Creator
Author

Thank you for reply..