topic Re: i have a fact table ? in QlikView https://community.qlik.com/t5/QlikView/i-have-a-fact-table/m-p/796038#M1040695 <HTML><HEAD></HEAD><BODY><P>in a field?</P><P>nullcount(fieldname)</P><P>count (distinct fieldname)</P></BODY></HTML> Mon, 08 Dec 2014 16:12:28 GMT maxgro 2014-12-08T16:12:28Z i have a fact table ? https://community.qlik.com/t5/QlikView/i-have-a-fact-table/m-p/796036#M1040692 <HTML><HEAD></HEAD><BODY><P>i want cross check my fact table ,how many null values and distinct values are there</P><P>i have only fact table ,how to check?</P></BODY></HTML> Mon, 08 Dec 2014 16:01:24 GMT https://community.qlik.com/t5/QlikView/i-have-a-fact-table/m-p/796036#M1040692 2014-12-08T16:01:24Z Re: i have a fact table ? https://community.qlik.com/t5/QlikView/i-have-a-fact-table/m-p/796037#M1040694 <HTML><HEAD></HEAD><BODY><P>For the distinct values you can go to the top menu bar Settings &gt; Document Properties &gt; Tables Tab.</P><P></P><P>Click on your table and it will tell you the numbers of values and distinct values.</P></BODY></HTML> Mon, 08 Dec 2014 16:04:39 GMT https://community.qlik.com/t5/QlikView/i-have-a-fact-table/m-p/796037#M1040694 jpapador 2014-12-08T16:04:39Z Re: i have a fact table ? https://community.qlik.com/t5/QlikView/i-have-a-fact-table/m-p/796038#M1040695 <HTML><HEAD></HEAD><BODY><P>in a field?</P><P>nullcount(fieldname)</P><P>count (distinct fieldname)</P></BODY></HTML> Mon, 08 Dec 2014 16:12:28 GMT https://community.qlik.com/t5/QlikView/i-have-a-fact-table/m-p/796038#M1040695 maxgro 2014-12-08T16:12:28Z