topic Re: set analysis in Management & Governance https://community.qlik.com/t5/Management-Governance/set-analysis/m-p/1460342#M11775 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count(DISTINCT File) - Count(DISTINCT {&lt;Doc = {"*"}&gt;} File)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>Count(DISTINCT {&lt;File = {"=Len(Trim(Doc)) = 0"}&gt;} File)</STRONG></P></BODY></HTML> Mon, 08 Jan 2018 12:15:28 GMT sunny_talwar 2018-01-08T12:15:28Z set analysis https://community.qlik.com/t5/Management-Governance/set-analysis/m-p/1460339#M11772 <HTML><HEAD></HEAD><BODY><P>Hello I would like to have the number of Files who don't have a Docs related (the - ones)</P><P></P><P>Thank you </P><P></P><P><IMG alt="FileDocs.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/189270_FileDocs.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 08 Jan 2018 11:11:11 GMT https://community.qlik.com/t5/Management-Governance/set-analysis/m-p/1460339#M11772 zied_ahmed1 2018-01-08T11:11:11Z Re: set analysis https://community.qlik.com/t5/Management-Governance/set-analysis/m-p/1460340#M11773 <HTML><HEAD></HEAD><BODY><P>NullCount(Docs) ??</P></BODY></HTML> Mon, 08 Jan 2018 11:14:47 GMT https://community.qlik.com/t5/Management-Governance/set-analysis/m-p/1460340#M11773 Anonymous 2018-01-08T11:14:47Z Re: set analysis https://community.qlik.com/t5/Management-Governance/set-analysis/m-p/1460341#M11774 <HTML><HEAD></HEAD><BODY><P>Hi Zied,</P><P></P><P>try like the bellow.</P><P></P><P>count({&lt;Docs={''}&gt;}File)</P><P></P><P></P><P>Regards</P><P>Sathish</P></BODY></HTML> Mon, 08 Jan 2018 11:56:51 GMT https://community.qlik.com/t5/Management-Governance/set-analysis/m-p/1460341#M11774 satheshreddy 2018-01-08T11:56:51Z Re: set analysis https://community.qlik.com/t5/Management-Governance/set-analysis/m-p/1460342#M11775 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count(DISTINCT File) - Count(DISTINCT {&lt;Doc = {"*"}&gt;} File)</STRONG></P><P></P><P>or</P><P></P><P><STRONG>Count(DISTINCT {&lt;File = {"=Len(Trim(Doc)) = 0"}&gt;} File)</STRONG></P></BODY></HTML> Mon, 08 Jan 2018 12:15:28 GMT https://community.qlik.com/t5/Management-Governance/set-analysis/m-p/1460342#M11775 sunny_talwar 2018-01-08T12:15:28Z