topic Re: What is the difference between Total Distinct Values and Present Distinct Values? in App Development https://community.qlik.com/t5/App-Development/What-is-the-difference-between-Total-Distinct-Values-and-Present/m-p/764673#M10795 <HTML><HEAD></HEAD><BODY><P>They are exactly what they say: Total number (in all tables) vs Present number (in this table). For a normal field, there is no difference.</P><P></P><P>But if the field is a key between tables, it may make a difference. For example, if you have values A and B in one table, and A and C in a second table, the total number of values is 3, but neither of the tables has more than 2 present values.</P><P></P><P>HIC</P></BODY></HTML> Sun, 22 Mar 2015 14:33:30 GMT hic 2015-03-22T14:33:30Z What is the difference between Total Distinct Values and Present Distinct Values? https://community.qlik.com/t5/App-Development/What-is-the-difference-between-Total-Distinct-Values-and-Present/m-p/764672#M10794 <HTML><HEAD></HEAD><BODY><P>Hello!</P><P></P><P>Can anybody please tell me what is the difference between Total Distinct Values and Present Distinct Values in a Table Previewer like below?</P><P></P><P>In my example it shows the same numbers but I am not sure what each one means. <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P></P><P><IMG alt="Capture.JPG" class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/81459_Capture.JPG" style="height: auto;" /></P></BODY></HTML> Sun, 22 Mar 2015 12:57:21 GMT https://community.qlik.com/t5/App-Development/What-is-the-difference-between-Total-Distinct-Values-and-Present/m-p/764672#M10794 2015-03-22T12:57:21Z Re: What is the difference between Total Distinct Values and Present Distinct Values? https://community.qlik.com/t5/App-Development/What-is-the-difference-between-Total-Distinct-Values-and-Present/m-p/764673#M10795 <HTML><HEAD></HEAD><BODY><P>They are exactly what they say: Total number (in all tables) vs Present number (in this table). For a normal field, there is no difference.</P><P></P><P>But if the field is a key between tables, it may make a difference. For example, if you have values A and B in one table, and A and C in a second table, the total number of values is 3, but neither of the tables has more than 2 present values.</P><P></P><P>HIC</P></BODY></HTML> Sun, 22 Mar 2015 14:33:30 GMT https://community.qlik.com/t5/App-Development/What-is-the-difference-between-Total-Distinct-Values-and-Present/m-p/764673#M10795 hic 2015-03-22T14:33:30Z Re: What is the difference between Total Distinct Values and Present Distinct Values? https://community.qlik.com/t5/App-Development/What-is-the-difference-between-Total-Distinct-Values-and-Present/m-p/764674#M10796 <HTML><HEAD></HEAD><BODY><P>I had the same question, so thank you for clarifying. I didn't find the terminology to be self-explanatory... The Help <A href="http://help.qlik.com/en-US/sense/June2017/Subsystems/Hub/Content/DataModeling/preview-tables-fields-data-model-viewer.htm">web page</A> dedicated to the Data Model Viewer could add a couple sentences about this.</P></BODY></HTML> Thu, 10 Aug 2017 20:40:23 GMT https://community.qlik.com/t5/App-Development/What-is-the-difference-between-Total-Distinct-Values-and-Present/m-p/764674#M10796 Lauri 2017-08-10T20:40:23Z