topic Month Range String Variable in QlikView https://community.qlik.com/t5/QlikView/Month-Range-String-Variable/m-p/1343835#M413707 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Sum({&lt;YearNo={$(=Max(YearNo))},MthName={'Jan','Feb','Mar','Apr','May'}&gt;}Plan_InvoiceSales)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>I need some help to either create a variable for&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">'Jan','Feb','Mar','Apr','May'&nbsp; which represents (beginning of the year to current month - 1) or use some sort of set analysis functionality to get identical results.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Any help would be appreciated.</SPAN></P></BODY></HTML> Fri, 09 Jun 2017 13:56:29 GMT 2017-06-09T13:56:29Z Month Range String Variable https://community.qlik.com/t5/QlikView/Month-Range-String-Variable/m-p/1343835#M413707 <HTML><HEAD></HEAD><BODY><P><SPAN style="font-size: 13.3333px;">Sum({&lt;YearNo={$(=Max(YearNo))},MthName={'Jan','Feb','Mar','Apr','May'}&gt;}Plan_InvoiceSales)</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P>I need some help to either create a variable for&nbsp;&nbsp;&nbsp; <SPAN style="font-size: 13.3333px;">'Jan','Feb','Mar','Apr','May'&nbsp; which represents (beginning of the year to current month - 1) or use some sort of set analysis functionality to get identical results.</SPAN></P><P><SPAN style="font-size: 13.3333px;"><BR /></SPAN></P><P><SPAN style="font-size: 13.3333px;">Any help would be appreciated.</SPAN></P></BODY></HTML> Fri, 09 Jun 2017 13:56:29 GMT https://community.qlik.com/t5/QlikView/Month-Range-String-Variable/m-p/1343835#M413707 2017-06-09T13:56:29Z