topic Variable Expression for SUM in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Variable-Expression-for-SUM/m-p/1323604#M6720 <HTML><HEAD></HEAD><BODY><P>I am trying to do bar chart with some selected month data QTY sum value only to display, so i planned to create Variable as expression to get input for Selected month. but it is not working...</P><P></P><P>Variable: </P><P>Variable Name: v2017Jun</P><P>Expression Formula: [Calendar Month-Year - RD]= {'Jan-2017','Feb-2017','Mar-2017','Apr-2017','May-2017','Jun-2017'</P><P></P><P>Expression formula i used in chart is..</P><P></P><P>=(Sum({$&lt;v2017JUN&gt;}[RW Qty]))</P><P></P><P>If i used this expression, chart accumulating all month RW QTY sum values, not which i selected month which i need...</P><P></P><P>If is fixed the variable, so i can use it at multiple chart for selected month, also i will add or delete some month in future too...</P><P></P><P>can any one help on this...</P></BODY></HTML> Fri, 02 Apr 2021 07:57:08 GMT Anonymous 2021-04-02T07:57:08Z Variable Expression for SUM https://community.qlik.com/t5/Connectivity-Data-Prep/Variable-Expression-for-SUM/m-p/1323604#M6720 <HTML><HEAD></HEAD><BODY><P>I am trying to do bar chart with some selected month data QTY sum value only to display, so i planned to create Variable as expression to get input for Selected month. but it is not working...</P><P></P><P>Variable: </P><P>Variable Name: v2017Jun</P><P>Expression Formula: [Calendar Month-Year - RD]= {'Jan-2017','Feb-2017','Mar-2017','Apr-2017','May-2017','Jun-2017'</P><P></P><P>Expression formula i used in chart is..</P><P></P><P>=(Sum({$&lt;v2017JUN&gt;}[RW Qty]))</P><P></P><P>If i used this expression, chart accumulating all month RW QTY sum values, not which i selected month which i need...</P><P></P><P>If is fixed the variable, so i can use it at multiple chart for selected month, also i will add or delete some month in future too...</P><P></P><P>can any one help on this...</P></BODY></HTML> Fri, 02 Apr 2021 07:57:08 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Variable-Expression-for-SUM/m-p/1323604#M6720 Anonymous 2021-04-02T07:57:08Z Re: Variable Expression for SUM https://community.qlik.com/t5/Connectivity-Data-Prep/Variable-Expression-for-SUM/m-p/1323605#M6721 <HTML><HEAD></HEAD><BODY><P>This isn't really a Qlik Web Connectors question, so you may be better off moving the conversation to another forum.</P><P></P><P>However... Your variable code appears to be missing a closing }.</P><P></P><P>Where you refer to the variable you are missing the dollar sign expansion, it should read:</P><P></P><P>=(Sum({$&lt;<STRONG>$(v2017Jun)</STRONG>&gt;}[RW Qty]))</P><P></P><P>Also, be careful as variables are case sensitive.</P><P></P><P>It's always a very good idea to ensure that your expressions are working well before you move things into variables, and then replace bits a little bit at a time - then you know which change (if any) breaks your expression.</P><P></P><P>Hope that helps.</P><P></P><P>Steve</P></BODY></HTML> Tue, 01 Aug 2017 08:17:38 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Variable-Expression-for-SUM/m-p/1323605#M6721 stevedark 2017-08-01T08:17:38Z Re: Variable Expression for SUM https://community.qlik.com/t5/Connectivity-Data-Prep/Variable-Expression-for-SUM/m-p/1323606#M6722 <HTML><HEAD></HEAD><BODY><P>Thanks Steve.... Its Working now......</P></BODY></HTML> Tue, 01 Aug 2017 08:32:53 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Variable-Expression-for-SUM/m-p/1323606#M6722 Anonymous 2017-08-01T08:32:53Z Re: Variable Expression for SUM https://community.qlik.com/t5/Connectivity-Data-Prep/Variable-Expression-for-SUM/m-p/1323607#M6723 <HTML><HEAD></HEAD><BODY><P>If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).</P><P>If not, please make clear what part of this topic you still need help with <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.</P></BODY></HTML> Tue, 01 Aug 2017 11:41:18 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Variable-Expression-for-SUM/m-p/1323607#M6723 oknotsen 2017-08-01T11:41:18Z Re: Variable Expression for SUM https://community.qlik.com/t5/Connectivity-Data-Prep/Variable-Expression-for-SUM/m-p/1323608#M6724 <HTML><HEAD></HEAD><BODY><P>Excellent.&nbsp; Thanks for letting me know that worked for you.</P></BODY></HTML> Tue, 01 Aug 2017 13:00:10 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Variable-Expression-for-SUM/m-p/1323608#M6724 stevedark 2017-08-01T13:00:10Z