topic Re: Specific field selection should effect the Sum(....), elsewise no effect is required in QlikView https://community.qlik.com/t5/QlikView/Specific-field-selection-should-effect-the-Sum-elsewise-no/m-p/1123751#M891062 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>Try this.</P><P></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=if(GetSelectedCount(FiscalYear)&gt; 0, concat (</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3366ff;">DISTINCT </SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #993300;">Mfg_Year</SPAN><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, ‘,’))</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Regards,</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Kaushik Solanki<BR /></SPAN></P></BODY></HTML> Wed, 17 Aug 2016 11:27:35 GMT kaushiknsolanki 2016-08-17T11:27:35Z Specific field selection should effect the Sum(....), elsewise no effect is required https://community.qlik.com/t5/QlikView/Specific-field-selection-should-effect-the-Sum-elsewise-no/m-p/1123750#M891061 <HTML><HEAD></HEAD><BODY><P>Hi Experts,</P><P></P><P>In an application, I have one filter with the name "FiscalYear"</P><P></P><P></P><P></P><P></P><P><SPAN style="color: #000000;">=if(GetSelectedCount(FiscalYear)&gt; 0, concat (<SPAN style="color: #3366ff;">DISTINCT </SPAN><SPAN style="color: #993300;">Mfg_Year</SPAN>, ‘,’), ‘*’ )</SPAN></P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Specific-field-selection-should-effect-the-Sum-elsewise-no/m-p/1123750#M891061 2020-11-25T16:16:04Z Re: Specific field selection should effect the Sum(....), elsewise no effect is required https://community.qlik.com/t5/QlikView/Specific-field-selection-should-effect-the-Sum-elsewise-no/m-p/1123751#M891062 <HTML><HEAD></HEAD><BODY><P>HI,</P><P></P><P>Try this.</P><P></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">=if(GetSelectedCount(FiscalYear)&gt; 0, concat (</SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3366ff;">DISTINCT </SPAN><SPAN style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #993300;">Mfg_Year</SPAN><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">, ‘,’))</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;"><BR /></SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Regards,</SPAN></P><P><SPAN style="color: #000000; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Kaushik Solanki<BR /></SPAN></P></BODY></HTML> Wed, 17 Aug 2016 11:27:35 GMT https://community.qlik.com/t5/QlikView/Specific-field-selection-should-effect-the-Sum-elsewise-no/m-p/1123751#M891062 kaushiknsolanki 2016-08-17T11:27:35Z Re: Specific field selection should effect the Sum(....), elsewise no effect is required https://community.qlik.com/t5/QlikView/Specific-field-selection-should-effect-the-Sum-elsewise-no/m-p/1123752#M891063 <HTML><HEAD></HEAD><BODY><P>And your question is?</P></BODY></HTML> Wed, 17 Aug 2016 11:31:36 GMT https://community.qlik.com/t5/QlikView/Specific-field-selection-should-effect-the-Sum-elsewise-no/m-p/1123752#M891063 jonathandienst 2016-08-17T11:31:36Z Re: Specific field selection should effect the Sum(....), elsewise no effect is required https://community.qlik.com/t5/QlikView/Specific-field-selection-should-effect-the-Sum-elsewise-no/m-p/1123753#M891064 <HTML><HEAD></HEAD><BODY><P>Good question <A href="https://community.qlik.com/people/jontydkpi">jontydkpi</A></P></BODY></HTML> Wed, 17 Aug 2016 11:34:43 GMT https://community.qlik.com/t5/QlikView/Specific-field-selection-should-effect-the-Sum-elsewise-no/m-p/1123753#M891064 sunny_talwar 2016-08-17T11:34:43Z Re: Specific field selection should effect the Sum(....), elsewise no effect is required https://community.qlik.com/t5/QlikView/Specific-field-selection-should-effect-the-Sum-elsewise-no/m-p/1123754#M891065 <HTML><HEAD></HEAD><BODY><P>Please accept my apologies, by mistake I posted question incomplete question there is complete question is posted with the following subject please:</P><P></P><P><A _jive_internal="true" href="https://community.qlik.com/thread/229386?sr=inbox"><SPAN style="color: #0066cc; text-decoration: underline;">Expression's value should only take effect with one filter only</SPAN></A></P></BODY></HTML> Wed, 17 Aug 2016 11:48:18 GMT https://community.qlik.com/t5/QlikView/Specific-field-selection-should-effect-the-Sum-elsewise-no/m-p/1123754#M891065 2016-08-17T11:48:18Z