topic How to write set expression? in QlikView https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520684#M194535 <HTML><HEAD></HEAD><BODY><P>How to write setexpression below conditons</P><P></P><P><SPAN style="color: #ff0000; font-size: 14pt;">if(guid&gt;=1,count(distinct((guid)))/if(Serialno &gt;=1,count(distinct(Serialno))</SPAN></P><P></P><P></P><P>Thnks,</P></BODY></HTML> Fri, 28 Jun 2013 12:06:59 GMT 2013-06-28T12:06:59Z How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520684#M194535 <HTML><HEAD></HEAD><BODY><P>How to write setexpression below conditons</P><P></P><P><SPAN style="color: #ff0000; font-size: 14pt;">if(guid&gt;=1,count(distinct((guid)))/if(Serialno &gt;=1,count(distinct(Serialno))</SPAN></P><P></P><P></P><P>Thnks,</P></BODY></HTML> Fri, 28 Jun 2013 12:06:59 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520684#M194535 2013-06-28T12:06:59Z Re: How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520685#M194536 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Something like this:</P><P></P><P>Count({&lt;guid={"&gt;=1"}&gt;} Distinct guid) / Count({&lt;Serialno={"&gt;=1"}&gt;} Distinct Serialno)</P><P></P><P>Regards</P><P>Jonathan</P></BODY></HTML> Fri, 28 Jun 2013 12:11:43 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520685#M194536 jonathandienst 2013-06-28T12:11:43Z Re: How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520686#M194537 <HTML><HEAD></HEAD><BODY><P>its not giving the output</P><P>it giving zero value</P></BODY></HTML> Fri, 28 Jun 2013 12:18:37 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520686#M194537 2013-06-28T12:18:37Z Re: How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520687#M194538 <HTML><HEAD></HEAD><BODY><P>can u provide us a sample Qvw</P></BODY></HTML> Fri, 28 Jun 2013 14:54:13 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520687#M194538 Anonymous 2013-06-28T14:54:13Z