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: 
Not applicable

sum between dates

hi all,

could someone assist with syntax here. I'm trying to sum between the beginning of year to the current date.

Sum({<Date = {">=$(vYearStart) <=$(vToday)"} >} Field)  

vYearStart= YearStart(Today()) 

vToday =Date(Today())

5 Replies
sunny_talwar

May be try like this

Sum({<Date = {">=$(=vYearStart) <=$(=vToday)"}>} Field)

Also, look here:

Dates in Set Analysis

Not applicable
Author

Ah I figured out syntax wasn't the issue. The field I am summing does not have a date link. Only a month. Is there a way to do a sum between first month of the year and the current month?

sunny_talwar

How does your Month field look like?

Not applicable
Author

Its written out fully

January

February

March

etc

sunny_talwar

And can you share how is this field created in the script? Essentially, is this a date field or not?