Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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)

0 Replies