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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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?