topic How to insert condition to none SET expression ? in QlikView https://community.qlik.com/t5/QlikView/How-to-insert-condition-to-none-SET-expression/m-p/1050454#M637702 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>I have below expression :-</P><P></P><P></P><P>sum(DISTINCT&nbsp; NET_PROFIT_A_TAX_C)</P><P>/</P><P>sum(DISTINCT&nbsp; REVENUE_C)</P><P></P><P></P><P>May i know how to insert the below condition to&nbsp; above expression :-</P><P></P><P></P><P>COMPETITOR = {'WAGO', 'iTDS')</P><P></P><P></P><P>Paul</P></BODY></HTML> Mon, 04 Apr 2016 23:33:01 GMT paulyeo11 2016-04-04T23:33:01Z How to insert condition to none SET expression ? https://community.qlik.com/t5/QlikView/How-to-insert-condition-to-none-SET-expression/m-p/1050454#M637702 <HTML><HEAD></HEAD><BODY><P>Hi All</P><P></P><P></P><P>I have below expression :-</P><P></P><P></P><P>sum(DISTINCT&nbsp; NET_PROFIT_A_TAX_C)</P><P>/</P><P>sum(DISTINCT&nbsp; REVENUE_C)</P><P></P><P></P><P>May i know how to insert the below condition to&nbsp; above expression :-</P><P></P><P></P><P>COMPETITOR = {'WAGO', 'iTDS')</P><P></P><P></P><P>Paul</P></BODY></HTML> Mon, 04 Apr 2016 23:33:01 GMT https://community.qlik.com/t5/QlikView/How-to-insert-condition-to-none-SET-expression/m-p/1050454#M637702 paulyeo11 2016-04-04T23:33:01Z Re: How to insert condition to none SET expression ? https://community.qlik.com/t5/QlikView/How-to-insert-condition-to-none-SET-expression/m-p/1050455#M637703 <HTML><HEAD></HEAD><BODY><P>my QV Doc</P></BODY></HTML> Mon, 04 Apr 2016 23:33:56 GMT https://community.qlik.com/t5/QlikView/How-to-insert-condition-to-none-SET-expression/m-p/1050455#M637703 paulyeo11 2016-04-04T23:33:56Z Re: How to insert condition to none SET expression ? https://community.qlik.com/t5/QlikView/How-to-insert-condition-to-none-SET-expression/m-p/1050456#M637704 <HTML><HEAD></HEAD><BODY><P>May be like this:</P><P></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Sum(DISTINCT {&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">COMPETITOR = {'WAGO', 'iTDS'}</SPAN>&gt;} NET_PROFIT_A_TAX_C)</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>/</STRONG></P><P style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><STRONG>Sum(DISTINCT <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">{&lt;</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">COMPETITOR = {'WAGO', 'iTDS'}</SPAN><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">&gt;}</SPAN> REVENUE_C)</STRONG></P></BODY></HTML> Mon, 04 Apr 2016 23:34:16 GMT https://community.qlik.com/t5/QlikView/How-to-insert-condition-to-none-SET-expression/m-p/1050456#M637704 sunny_talwar 2016-04-04T23:34:16Z