topic Re: Set analysis in Management & Governance https://community.qlik.com/t5/Management-Governance/Set-analysis/m-p/1456913#M11669 <HTML><HEAD></HEAD><BODY><P>How about this</P><P></P><P><STRONG>Count(DISTINCT {&lt;doc = {"=N<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">um#(Interval(Field2 - Field1, 'mm'),'###') &gt;30"}</SPAN>&gt;} doc)</STRONG></P></BODY></HTML> Tue, 02 Jan 2018 13:52:10 GMT sunny_talwar 2018-01-02T13:52:10Z Set analysis https://community.qlik.com/t5/Management-Governance/Set-analysis/m-p/1456912#M11668 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P>I have this KPI :</P><P></P><P>Count(doc)</P><P></P><P>and i need to this condition to have just the number of docs who have values &gt;30&nbsp; : </P><P></P><P>if(num(num#(interval(Field2-Field1,'mm'),'###'))&gt;30)</P><P></P><P>how to do this with set analysis </P><P></P><P>Thanks </P></BODY></HTML> Tue, 02 Jan 2018 13:50:37 GMT https://community.qlik.com/t5/Management-Governance/Set-analysis/m-p/1456912#M11668 zied_ahmed1 2018-01-02T13:50:37Z Re: Set analysis https://community.qlik.com/t5/Management-Governance/Set-analysis/m-p/1456913#M11669 <HTML><HEAD></HEAD><BODY><P>How about this</P><P></P><P><STRONG>Count(DISTINCT {&lt;doc = {"=N<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">um#(Interval(Field2 - Field1, 'mm'),'###') &gt;30"}</SPAN>&gt;} doc)</STRONG></P></BODY></HTML> Tue, 02 Jan 2018 13:52:10 GMT https://community.qlik.com/t5/Management-Governance/Set-analysis/m-p/1456913#M11669 sunny_talwar 2018-01-02T13:52:10Z