topic Help with Set analysis Month Year-to-Date, with date not provided in App Development https://community.qlik.com/t5/App-Development/Help-with-Set-analysis-Month-Year-to-Date-with-date-not-provided/m-p/32324#M2180 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Im trying to get the year to date table presented in month, I need the month name and budget data to be shown in the table.</P><P></P><P>However, date is not provided for the budget data only the month and the year available, so that budget data could not be linked to the date created from master calendar. I could not figure out the solution to get it solved. The script below doesn't work, any help would be very much appreciated.</P><P></P><P>=sum({&lt;Month={"&gt;=$(=Num(Month(Yearstart(Date))))&lt;=$(=Num(Month(Max(Date)))"}, Year= {'$(=Year(Date))'}&gt;}Budget)</P></BODY></HTML> Fri, 13 Apr 2018 09:44:58 GMT Anonymous 2018-04-13T09:44:58Z Help with Set analysis Month Year-to-Date, with date not provided https://community.qlik.com/t5/App-Development/Help-with-Set-analysis-Month-Year-to-Date-with-date-not-provided/m-p/32324#M2180 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Im trying to get the year to date table presented in month, I need the month name and budget data to be shown in the table.</P><P></P><P>However, date is not provided for the budget data only the month and the year available, so that budget data could not be linked to the date created from master calendar. I could not figure out the solution to get it solved. The script below doesn't work, any help would be very much appreciated.</P><P></P><P>=sum({&lt;Month={"&gt;=$(=Num(Month(Yearstart(Date))))&lt;=$(=Num(Month(Max(Date)))"}, Year= {'$(=Year(Date))'}&gt;}Budget)</P></BODY></HTML> Fri, 13 Apr 2018 09:44:58 GMT https://community.qlik.com/t5/App-Development/Help-with-Set-analysis-Month-Year-to-Date-with-date-not-provided/m-p/32324#M2180 Anonymous 2018-04-13T09:44:58Z