Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
vangurideepu
Contributor

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
Esteemed Contributor II

Re: Hi Qlik Experts... I have Data Model Query in Qlik sense.

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

vinieme12
Esteemed Contributor II

Re: Hi Qlik Experts... I have Data Model Query in Qlik sense.

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

displayed in the tool tip.

vangurideepu
Contributor

Re: Hi Qlik Experts... I have Data Model Query in Qlik sense.

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
Esteemed Contributor II

Re: Hi Qlik Experts... I have Data Model Query in Qlik sense.

there is ABSOLUTELY NO SUCH RULE

vinieme12
Esteemed Contributor II

Re: Hi Qlik Experts... I have Data Model Query in Qlik sense.

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.

vangurideepu
Contributor

Re: Hi Qlik Experts... I have Data Model Query in Qlik sense.

Thank you for reply..