Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
samvile18
Creator III
Creator III

Set analysis help!

Hi,

Can anyone help me please?

I have the following syntax that I use to calculate a YTD Forecast figure, I need to change it so instead of it calculating up to todays date...it calculates up to 31/07/2011

=Sum({$<Year = {2011},Measure={'Budget'}, Period={"<=$(=Today())"}>}Value)/1000

Many thanks in advance

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try replacing the today() with makedate(2011,07,31)

Stefan

View solution in original post

2 Replies
swuehl
MVP
MVP

Try replacing the today() with makedate(2011,07,31)

Stefan

samvile18
Creator III
Creator III
Author

Stefan...YOU'RE AWESOME!!