topic Re: Set expression in QlikView https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357294#M832261 <HTML><HEAD></HEAD><BODY><P>Count({&lt;Product={"=Count(sales)&gt;1"}&gt;}Product)</P></BODY></HTML> Tue, 13 Jun 2017 07:55:07 GMT tresB 2017-06-13T07:55:07Z Set expression https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357290#M832257 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P><IMG alt="Pic.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/166643_Pic.PNG" style="height: auto;" /></P><P>From this table find out the product where count(sales) &gt;0 </P><P></P><P>How to write the set expression for that?</P><P></P><P>Thanks In advance</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357290#M832257 prabhas277 2020-11-25T16:16:04Z Re: Set expression https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357291#M832258 <HTML><HEAD></HEAD><BODY><P>Sorry </P><P></P><P>Find out the product where count(sales)&gt;1</P></BODY></HTML> Tue, 13 Jun 2017 07:52:08 GMT https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357291#M832258 prabhas277 2017-06-13T07:52:08Z Re: Set expression https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357292#M832259 <HTML><HEAD></HEAD><BODY><P>May be this</P><P></P><P><STRONG>Count(DISTINCT {&lt;product = {"=Count(Sales) &gt; 1"}&gt;}product)</STRONG></P></BODY></HTML> Tue, 13 Jun 2017 07:53:48 GMT https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357292#M832259 sunny_talwar 2017-06-13T07:53:48Z Re: Set expression https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357293#M832260 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>did you try if(count(sales)&gt;0,1,0)</P><P></P><P>Ariel</P></BODY></HTML> Tue, 13 Jun 2017 07:54:09 GMT https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357293#M832260 ariel_klien 2017-06-13T07:54:09Z Re: Set expression https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357294#M832261 <HTML><HEAD></HEAD><BODY><P>Count({&lt;Product={"=Count(sales)&gt;1"}&gt;}Product)</P></BODY></HTML> Tue, 13 Jun 2017 07:55:07 GMT https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357294#M832261 tresB 2017-06-13T07:55:07Z Re: Set expression https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357295#M832262 <HTML><HEAD></HEAD><BODY><P>For that I am getting output 0</P></BODY></HTML> Tue, 13 Jun 2017 08:13:12 GMT https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357295#M832262 prabhas277 2017-06-13T08:13:12Z Re: Set expression https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357296#M832263 <HTML><HEAD></HEAD><BODY><P>May be your field name is sales and not Sales... have you made sure that the field names are read correct?</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Count(DISTINCT {&lt;product = {"=Count(<SPAN style="color: #ff0000; font-size: 14pt;">s</SPAN>ales) &gt; 1"}&gt;}product)</STRONG></P></BODY></HTML> Tue, 13 Jun 2017 08:15:48 GMT https://community.qlik.com/t5/QlikView/Set-expression/m-p/1357296#M832263 sunny_talwar 2017-06-13T08:15:48Z