topic Variable Help in QlikView https://community.qlik.com/t5/QlikView/Variable-Help/m-p/760181#M270454 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am looking for some help regarding setting up a variable.&nbsp; I am looking for a variable that selects all months up to the current if no months are selected, or sums up to the selected month.</P><P></P><P>Example - I have data through February so with no selection should sum through Feb.&nbsp; Otherwise sum through other months selected.&nbsp; I need this to be dynamic and I believe I have some of the working parts, I just cannot get them to all work properly.</P><P></P><P>variable to set up -</P><P>vMaxSumMonth - =if(GetSelectedCount([MONTH-NUMERIC])&lt;&gt;1,$(vMaxSumMonthPart1),$(vMaxSumMonthPart2))</P><P></P><P>Parts I am getting wrong-</P><P>vMaxSumMonthPart1 = "&lt;=$(=vBusinessMonthNumber)" or sum up through current Business Month number which is 2</P><P>vMaxSumMonthPart2 = "&lt;=$(=max({&lt;YEAR={$(=max(YEAR))}&gt;} [MONTH-NUMERIC]))" or sum up through max possible month of 2015</P><P></P><P>Thank you,</P><P></P><P>Justin</P></BODY></HTML> Fri, 20 Mar 2015 14:24:37 GMT Anonymous 2015-03-20T14:24:37Z Variable Help https://community.qlik.com/t5/QlikView/Variable-Help/m-p/760181#M270454 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>I am looking for some help regarding setting up a variable.&nbsp; I am looking for a variable that selects all months up to the current if no months are selected, or sums up to the selected month.</P><P></P><P>Example - I have data through February so with no selection should sum through Feb.&nbsp; Otherwise sum through other months selected.&nbsp; I need this to be dynamic and I believe I have some of the working parts, I just cannot get them to all work properly.</P><P></P><P>variable to set up -</P><P>vMaxSumMonth - =if(GetSelectedCount([MONTH-NUMERIC])&lt;&gt;1,$(vMaxSumMonthPart1),$(vMaxSumMonthPart2))</P><P></P><P>Parts I am getting wrong-</P><P>vMaxSumMonthPart1 = "&lt;=$(=vBusinessMonthNumber)" or sum up through current Business Month number which is 2</P><P>vMaxSumMonthPart2 = "&lt;=$(=max({&lt;YEAR={$(=max(YEAR))}&gt;} [MONTH-NUMERIC]))" or sum up through max possible month of 2015</P><P></P><P>Thank you,</P><P></P><P>Justin</P></BODY></HTML> Fri, 20 Mar 2015 14:24:37 GMT https://community.qlik.com/t5/QlikView/Variable-Help/m-p/760181#M270454 Anonymous 2015-03-20T14:24:37Z Re: Variable Help https://community.qlik.com/t5/QlikView/Variable-Help/m-p/760182#M270455 <HTML><HEAD></HEAD><BODY><P>Just wanted to follow up if anyone had a chance to see my problem and had any thoughts.</P><P></P><P>Thanks again for the help,</P><P></P><P>Justin</P></BODY></HTML> Tue, 24 Mar 2015 18:50:39 GMT https://community.qlik.com/t5/QlikView/Variable-Help/m-p/760182#M270455 Anonymous 2015-03-24T18:50:39Z