topic Re: rookie question - dynamically determine variable value in doing a sum in QlikView https://community.qlik.com/t5/QlikView/rookie-question-dynamically-determine-variable-value-in-doing-a/m-p/1255849#M518965 <HTML><HEAD></HEAD><BODY><P>Hi Raj,</P><P></P><P>=Sum({$&lt;Month={"<STRONG>$(=date(Today(),'MMMM'))"</STRONG>}&gt;} [Total WO])</P><P></P><P><STRONG>Scrrenshot from Help file:</STRONG></P><P><IMG __jive_id="143965" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143965_Capture.PNG" style="height: 170px; width: 620px;" /></P></BODY></HTML> Wed, 16 Nov 2016 02:42:01 GMT tamilarasu 2016-11-16T02:42:01Z rookie question - dynamically determine variable value in doing a sum https://community.qlik.com/t5/QlikView/rookie-question-dynamically-determine-variable-value-in-doing-a/m-p/1255848#M518964 <HTML><HEAD></HEAD><BODY><P>this may be a rookie question, so your patience is greatly appreciated- I'm trying to dynamicaly determine the current month (November) and then do a total only for that month..here's the expression i'm using ...<SPAN style="font-size: 8pt;">=</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Sum</SPAN><SPAN style="font-size: 8pt;">({$&lt;</SPAN><SPAN style="color: #800000; font-size: 8pt;">Month</SPAN><SPAN style="font-size: 8pt;">={'date(Today(),"MMMM")'}&gt;} </SPAN><SPAN style="color: #800000; font-size: 8pt;">[Total WO]</SPAN><SPAN style="font-size: 8pt;">) ..obviously doing something wrong...</SPAN></P><P></P><P><SPAN style="font-size: 8pt;">thx</SPAN></P><P></P></BODY></HTML> Wed, 16 Nov 2016 02:22:07 GMT https://community.qlik.com/t5/QlikView/rookie-question-dynamically-determine-variable-value-in-doing-a/m-p/1255848#M518964 Rkota 2016-11-16T02:22:07Z Re: rookie question - dynamically determine variable value in doing a sum https://community.qlik.com/t5/QlikView/rookie-question-dynamically-determine-variable-value-in-doing-a/m-p/1255849#M518965 <HTML><HEAD></HEAD><BODY><P>Hi Raj,</P><P></P><P>=Sum({$&lt;Month={"<STRONG>$(=date(Today(),'MMMM'))"</STRONG>}&gt;} [Total WO])</P><P></P><P><STRONG>Scrrenshot from Help file:</STRONG></P><P><IMG __jive_id="143965" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/143965_Capture.PNG" style="height: 170px; width: 620px;" /></P></BODY></HTML> Wed, 16 Nov 2016 02:42:01 GMT https://community.qlik.com/t5/QlikView/rookie-question-dynamically-determine-variable-value-in-doing-a/m-p/1255849#M518965 tamilarasu 2016-11-16T02:42:01Z Re: rookie question - dynamically determine variable value in doing a sum https://community.qlik.com/t5/QlikView/rookie-question-dynamically-determine-variable-value-in-doing-a/m-p/1255850#M518966 <HTML><HEAD></HEAD><BODY><P>Worked!!!...Thanks a ton...Tamil Nagaraj..and big hearty Vanakkam to you.&nbsp; Much appreciated.</P></BODY></HTML> Wed, 16 Nov 2016 02:48:44 GMT https://community.qlik.com/t5/QlikView/rookie-question-dynamically-determine-variable-value-in-doing-a/m-p/1255850#M518966 Rkota 2016-11-16T02:48:44Z Re: rookie question - dynamically determine variable value in doing a sum https://community.qlik.com/t5/QlikView/rookie-question-dynamically-determine-variable-value-in-doing-a/m-p/1255851#M518967 <HTML><HEAD></HEAD><BODY><P>Ha ha ha. No problem bro <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" />.&nbsp; <SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Please close the thread by marking correct answer.</SPAN></P></BODY></HTML> Wed, 16 Nov 2016 02:53:19 GMT https://community.qlik.com/t5/QlikView/rookie-question-dynamically-determine-variable-value-in-doing-a/m-p/1255851#M518967 tamilarasu 2016-11-16T02:53:19Z