topic Re: How to write set expression? in QlikView https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520236#M194395 <HTML><HEAD></HEAD><BODY><P>=count({$&lt;BusinessprocessStatus={"New"}&gt;}distinct(departmentguid))</P></BODY></HTML> Fri, 28 Jun 2013 08:23:37 GMT newqlikie 2013-06-28T08:23:37Z How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520232#M194391 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #0000ff; font-size: 12pt;">&nbsp; how to write set expression for below code</SPAN></P><P></P><P></P><P></P><P><SPAN style="color: #0000ff; font-size: 8pt;"></SPAN></P><P><SPAN style="font-size: 14pt;">count ({&lt;<SPAN style="color: #800000;">BusinessProcessStatus</SPAN>={'New'} <SPAN style="color: #800000;">DepartmentGUID)</SPAN></SPAN></P><P></P></BODY></HTML> Fri, 28 Jun 2013 08:08:57 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520232#M194391 2013-06-28T08:08:57Z Re: How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520233#M194392 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>try this:</P><P></P><P><SPAN style="font-size: 14pt;">count ({$&lt;<SPAN style="color: #800000;">BusinessProcessStatus</SPAN>={'New'}&gt;} <SPAN style="color: #800000;">DepartmentGUID)</SPAN></SPAN></P><P></P><P>Regards</P></BODY></HTML> Fri, 28 Jun 2013 08:11:22 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520233#M194392 newqlikie 2013-06-28T08:11:22Z Re: How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520234#M194393 <HTML><HEAD></HEAD><BODY><P>=count({$&lt;BusinessprocessStatus={"New"}&gt;}departmentguid)</P></BODY></HTML> Fri, 28 Jun 2013 08:12:05 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520234#M194393 nizamsha 2013-06-28T08:12:05Z Re: How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520235#M194394 <HTML><HEAD></HEAD><BODY><P>Hi thanks</P><P>its working fine </P><P><SPAN style="color: #ff0000; font-size: 14pt;">but i want distinct department guid.</SPAN></P><P></P><P>thanks</P></BODY></HTML> Fri, 28 Jun 2013 08:20:59 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520235#M194394 2013-06-28T08:20:59Z Re: How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520236#M194395 <HTML><HEAD></HEAD><BODY><P>=count({$&lt;BusinessprocessStatus={"New"}&gt;}distinct(departmentguid))</P></BODY></HTML> Fri, 28 Jun 2013 08:23:37 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520236#M194395 newqlikie 2013-06-28T08:23:37Z Re: How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520237#M194396 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt; color: blue; font-family: 'Courier New';">count</SPAN><SPAN style="font-size: 8pt; color: black; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 8pt; color: blue; font-family: 'Courier New';">DISTINCT</SPAN><SPAN style="font-size: 8pt; color: black; font-family: 'Courier New';">{$&lt;BusinessprocessStatus={</SPAN><SPAN style="font-size: 8pt; color: maroon; font-family: 'Courier New';">"New"</SPAN><SPAN style="font-size: 8pt; color: black; font-family: 'Courier New';">}&gt;}departmentguid) </SPAN></P></BODY></HTML> Fri, 28 Jun 2013 08:31:41 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520237#M194396 2013-06-28T08:31:41Z Re: How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520238#M194397 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 8pt; color: blue; font-family: 'Courier New';">count</SPAN><SPAN style="font-size: 8pt; color: black; font-family: 'Courier New';">(</SPAN><SPAN style="font-size: 8pt; color: blue; font-family: 'Courier New';">DISTINCT</SPAN><SPAN style="font-size: 8pt; color: black; font-family: 'Courier New';">{$&lt;BusinessprocessStatus={</SPAN><SPAN style="font-size: 8pt; color: maroon; font-family: 'Courier New';">"New"</SPAN><SPAN style="font-size: 8pt; color: black; font-family: 'Courier New';">}&gt;}departmentguid</SPAN></P></BODY></HTML> Fri, 28 Jun 2013 08:45:07 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520238#M194397 nizamsha 2013-06-28T08:45:07Z Re: How to write set expression? https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520239#M194398 <HTML><HEAD></HEAD><BODY><P>try this</P><P><STRONG>=count(Distinct&nbsp; {$&lt;BusinessprocessStatus={"New"}&gt;}departmentguid)</STRONG></P></BODY></HTML> Fri, 28 Jun 2013 10:53:10 GMT https://community.qlik.com/t5/QlikView/How-to-write-set-expression/m-p/520239#M194398 2013-06-28T10:53:10Z