topic Re: Need help on expression creation in QlikView https://community.qlik.com/t5/QlikView/Need-help-on-expression-creation/m-p/1144881#M374753 <HTML><HEAD></HEAD><BODY><P>That is what I am not sure about. Can you provide few rows of data with expected output you are looking to get?</P></BODY></HTML> Wed, 29 Jun 2016 19:17:39 GMT sunny_talwar 2016-06-29T19:17:39Z Need help on expression creation https://community.qlik.com/t5/QlikView/Need-help-on-expression-creation/m-p/1144878#M374750 <HTML><HEAD></HEAD><BODY><P>Hi All , I want to create an set analysis expression for below rule , </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="602"><TBODY><TR><TD class="xl63" height="21" width="602"><SPAN lang="EN-GB">Count(Distinct(Group_Name) )where sum(SAVINGS_USD &lt; 0) over partition of group_Supplier</SPAN></TD></TR></TBODY></TABLE></BODY></HTML> Wed, 29 Jun 2016 16:55:24 GMT https://community.qlik.com/t5/QlikView/Need-help-on-expression-creation/m-p/1144878#M374750 agni_gold 2016-06-29T16:55:24Z Re: Need help on expression creation https://community.qlik.com/t5/QlikView/Need-help-on-expression-creation/m-p/1144879#M374751 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P><STRONG>Count(DISTINCT {&lt;Group_Name = {"=Sum(SAVINGS_USD) &lt; 0"}&gt;} Group_Name)</STRONG></P><P></P><P>Please provide a sample if the above doesn't work for you.</P></BODY></HTML> Wed, 29 Jun 2016 17:13:05 GMT https://community.qlik.com/t5/QlikView/Need-help-on-expression-creation/m-p/1144879#M374751 sunny_talwar 2016-06-29T17:13:05Z Re: Need help on expression creation https://community.qlik.com/t5/QlikView/Need-help-on-expression-creation/m-p/1144880#M374752 <HTML><HEAD></HEAD><BODY><P>what about <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">over partition of group_Supplier</SPAN></P></BODY></HTML> Wed, 29 Jun 2016 18:48:24 GMT https://community.qlik.com/t5/QlikView/Need-help-on-expression-creation/m-p/1144880#M374752 agni_gold 2016-06-29T18:48:24Z Re: Need help on expression creation https://community.qlik.com/t5/QlikView/Need-help-on-expression-creation/m-p/1144881#M374753 <HTML><HEAD></HEAD><BODY><P>That is what I am not sure about. Can you provide few rows of data with expected output you are looking to get?</P></BODY></HTML> Wed, 29 Jun 2016 19:17:39 GMT https://community.qlik.com/t5/QlikView/Need-help-on-expression-creation/m-p/1144881#M374753 sunny_talwar 2016-06-29T19:17:39Z