Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

chrischeang
New Contributor

Help with Set analysis Month Year-to-Date, with date not provided

Hi,

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.

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.

=sum({<Month={">=$(=Num(Month(Yearstart(Date))))<=$(=Num(Month(Max(Date)))"}, Year= {'$(=Year(Date))'}>}Budget)

Community Browser